View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
babs babs is offline
external usenet poster
 
Posts: 38
Default Command Button not copying with attached macro, help

I have a command button that executes a macro when clicked.
I have another macro that makes a copy of my template sheet.
If I manually make a copy of the template sheet, the button copies along
with the attached macro. If I used the macro to make a copy, the button is
copied with the text "Button 2" and does not bring the attached macro with it.
When I recorded the macro for copying the sheet, I used the same steps that
I use when doing it manually.
What am I doing wrong?

TIA