If you copy that sheet (not just the cells), then the code behind the worksheet
will be under the new sheet, too.

In code, it would be the equivalent of Edit|Move or copy sheet.

Josh wrote:

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

--

Dave Peterson