How to make a commandbutton show in all sheets?

Hey,

can someone tell me how I make buttons show in all sheets and in all newly created sheets?

I have about 10 sheets wit the same commandbuttons with these same codes asigned to them by copying these codes for every sheet.

Please Login or Register  to view this content.

Can I not put these codes in the "This workbook" and only make these commandbuttons on sheet1. So all the other sheets display these buttons to and also work with the codes?

No, that wouldn't work. Why not put the button on a toolbar instead - then you only need one?

That doesn't matter. You can have the workbook create the button when it's opened and delete it again when closed? Would that work for you?

You will need to move your code to a macro in a normal module. Then add a new normal module and paste this in - you need to alter the caption and macro name constants at the top as necessary:

Please Login or Register  to view this content.

then in the ThisWorkbook module you need code like this:

Please Login or Register  to view this content.

If you need more than one button, then you need multiple passes of this bit of the code:

Please Login or Register  to view this content.

changing the caption and macro name each time (or use the same macro and pass different parameters).
Without really knowing the details of what you are doing, I can't be more specific.

Please Login or Register  to view this content.

I get more buttons but they state all false?

UPDATE: allright I got it working
thx man

You shouldn't have the constant in there:

Please Login or Register  to view this content.

FYI, for multiple buttons, you might want to have a look at this article by John Walkenbach for a table-driven approach.