View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Josh Josh is offline
external usenet poster
 
Posts: 103
Default Copying VBA Code from one Sheet to another

Hello!
I have a template that creates 5 sheets. I would like the code from
sheet 1 and sheet 1's properties to be copied over to the 5 created sheets.
They are created with VBA. Is this possible? I have posted elsewhere with no
response. For example, I have buttons on the first sheet that do certain
things with the code for those buttons being within that sheet. When the 5
other sheets are created I can get the sheets to duplicate as far as
appearance but I cannot get the buttons to retain the functionality of the
first sheet.

Thanks!
Josh