Copying and renaming worksheets
 

Hi,

I'm new to this VBA programming, but have managed to get reasonably far with
it. But I still have one problem.
I am trying to let a user copy a sheet (to the end of the workbook, easy
enough), rename it myself in code (easy enough), and then send an existing
sheet to the end of the workbook (makes sure that my summary sheet is always
last).
Now... All my VBA code is in a module, except for some button click code in
each sheet (which calls into my module). The problem I have is that when I
copy a sheet, I need to be able to copy the buttons on the sheet, and the
code behind those buttons.

Does anyone know how I can do this? I hope I have explained it properly.

Thanks for any help given.

John Young

Copying and renaming worksheets
 

If the buttons are commandbuttons from the control toolbox toolbar (and they
sound like the are) and the event code is in the worksheet code module (and
it sounds like it is), then copying the sheet should get both the buttons
and the code.

--
Regards,
Tom Ogilvy


John Young wrote in message
...
Hi,

I'm new to this VBA programming, but have managed to get reasonably far
with
it. But I still have one problem.
I am trying to let a user copy a sheet (to the end of the workbook, easy
enough), rename it myself in code (easy enough), and then send an existing
sheet to the end of the workbook (makes sure that my summary sheet is
always
last).
Now... All my VBA code is in a module, except for some button click code
in
each sheet (which calls into my module). The problem I have is that when
I
copy a sheet, I need to be able to copy the buttons on the sheet, and the
code behind those buttons.

Does anyone know how I can do this? I hope I have explained it properly.

Thanks for any help given.

John Young