How to Delete VBS code via VBA

[LetMeDoIt]

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]

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 here:

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

 

[LetMeDoIt]

thank you. I ended up by rewriting the code.
regards.