How do I keep the VBA with a copied worksheet

[Picto]

Hi

I have a worksheet with a command button that when clicked copies the worksheet, saves the copy and mails the copied worksheet to another user.

this was written using Excel 2003 the command button works and copies the code onto the new sheet. When this is used by an Excel 2002 user the code disappears from the copied sheet.....How do i keep it there?

Thanks in advance Shaun

[royUK]

IKt depends on what type of code it is. If it is in the Worksheet module then it will copy, if not you need to copy the workbook & delete unwanted sheets from the copy.

[Picto]

Hi

the code is attached to the worksheet, and works on my machine with 2003...when it is used by someone else,an excel 2002 user the code does not copy... could this need the references changed (most are version 11)?

Shaun

[royUK]

It depends what the code is doing? can you attach an example workbook/