Excel cmd button

[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..

 

[Guest]

is the code in the button or is the button calling a
private sub?

 

[Tom Ogilvy]

If you copy the worksheet, the code contained in that sheet module should be
copied as well. Your experience seems to be atypical.