I have an Excel worksheet to do with timers and recording time etc. And I
also have some other command buttons within that. One of them will create
(and does) a new workbook, with all the data and command buttons. The other
however should create a new worksheet with the all the other command buttons
and each time i press it, it just copys the data over, without the command
buttons. I need it to copy the command buttons and each time i press it i
want it to create one in a different worksheet, but it only does it in the
next one. And i am pretty stuck. Any help is much appreciated.

Are your buttons/controls from the control toolbox toolbar?

If yes, then the code associated with those controls will travel if you copy the
whole worksheet--not just the cells.

You'd do the equivalent in code of Edit|move or copy sheet.

If your code that does the copying doesn't copy this way, you may want to
consider changing that portion.

Paul23 wrote:

I have an Excel worksheet to do with timers and recording time etc. And I
also have some other command buttons within that. One of them will create
(and does) a new workbook, with all the data and command buttons. The other
however should create a new worksheet with the all the other command buttons
and each time i press it, it just copys the data over, without the command
buttons. I need it to copy the command buttons and each time i press it i
want it to create one in a different worksheet, but it only does it in the
next one. And i am pretty stuck. Any help is much appreciated.

--

Dave Peterson