Copy Button with worksheet

  • Thread starter Thread starter S. S.
  • Start date Start date
S

S. S.

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.
 
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
 
Back
Top