software

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

--

Dave Peterson