View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Anson[_2_] Anson[_2_] is offline
external usenet poster
 
Posts: 28
Default Button controls on worksheets

I have a worksheet with 4 command buttons. I wrote a macro to copy the entire worksheet to a new workbook (along with the macros referring to the command buttons). However, once I have copied the worksheet, the name of the command buttons changed to "commandbutton1", "commandbutton2", ... etc. For that reason, it won't read the orginial macros anymore (because the codes were written for the buttons with the orginal names). How do I change them back to the orginal names?