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

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

>-----Original Message-----
>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..
>
>.
>

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

--
Regards,
Tom Ogilvy

"Terry" <[email protected]> wrote in message
news:[email protected]...
> 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..
>