Command Button VBA code

[Terry]

Can anyone help? I have a xls file OfficeXP. I have
command buttons on it with vba code behind the buttons.
In one file that I have when I use the copy sheet function
it copies the button and the code behind the button to a
new sheet in the same file. In the other file when a
sheet is copied the button is copied but it does not have
any coding behind it. Why would these behave
differently? I want the code copied with the sheet and
button.
Thanks for any help..

 

[Dave Peterson]

It sounds like you have different buttons on the sheets.

There's a commandbutton on the control toolbox toolbar that has code associated
with its click event. This gets copied when the worksheet gets copied.

There's a button on the Forms toolbar that can have a macro assigned to it.
This code doesn't automatically get copied.

If you rightclick on a button and see "assign macro", it's a Forms toolbar
button. If you don't see that option, it's from the control toolbox toolbar.

(It sounds like the simplest approach for you would be to replace the forms
toolbar buttons with control toolbox toolbar buttons (and move/copy/adjust the
code).)

 

[Terry]

Thank you. Appreciate your help.
Thought you might like to know. It was not a form button
(no assign macro). Therefore, I figured maybe it was
corrupt some how or due to being an earlier version
brought into excel 2002. Therefore, I copied the coding
and created a new button and pasted it into. Copied the
sheet and it worked. Before that when I copied a sheet it
copied the button but gave it a new name cmdbutton1
without code.
Thank you for your help. I should have tried a new button
in the first place.

 

[Dave Peterson]

Glad you got it working.

Thank you. Appreciate your help.
Thought you might like to know. It was not a form button
(no assign macro). Therefore, I figured maybe it was
corrupt some how or due to being an earlier version
brought into excel 2002. Therefore, I copied the coding
and created a new button and pasted it into. Copied the
sheet and it worked. Before that when I copied a sheet it
copied the button but gave it a new name cmdbutton1
without code.
Thank you for your help. I should have tried a new button
in the first place.