Copying and renaming worksheets

[John Young]

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

 

[Tom Ogilvy]

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.