Copy Button with worksheet
 

When copying the contents of one worksheet to another
worksheet using a macro, is there a way to also copy a
button from the original worksheet to the duplicate
worksheet?

If not, is there an easy way to add code to the macro to
create a new button?


Thanks

S.

Copy Button with worksheet
 

Turn on the macro recorder and perform either action manually. Turn off the
macro recorder. You can then examine the code recorded.

A button with no macro assigned to it seems less than useful. Look at Chip
Pearson's site for creating code with code:

http://www.cpearson.com/excel/vbe.htm


--
Regards,
Tom Ogilvy

"S. S." wrote in message
...
When copying the contents of one worksheet to another
worksheet using a macro, is there a way to also copy a
button from the original worksheet to the duplicate
worksheet?

If not, is there an easy way to add code to the macro to
create a new button?


Thanks

S.