Depending on the security setting that each user has chosen (and it's the user's
security setting--not something you can change), you may be able to use Chip
Pearson's notes he

http://cpearson.com/excel/vbe.htm

LetMeDoIt wrote:

Greetings,
I am running some macros that copies the current excel file to another
based on a certain condition. I would like to also delete the VBA
code from the copied file.

Can anyone point me to the correct call?

Any help is greatly appreciated.

(from microsoft.public.excel.programming )
regards.

--

Dave Peterson