macro to delete another macro
 

Can a macro be created to delete another macro.

I have a file that when opened, a macro runs to save the file, run some
processes, then saves as another file. However, when the new file is opened
that macro runs again. Is there a command that will delete the macro before
it saves?

Thanks.

macro to delete another macro
 

See Chip Pearson's excellent article 'Programming The VBA Editor' at
http://www.cpearson.com/excel/vbe.aspx

Bookmark his site and visit often...

"Gary McCarthy" wrote:

Can a macro be created to delete another macro.

I have a file that when opened, a macro runs to save the file, run some
processes, then saves as another file. However, when the new file is opened
that macro runs again. Is there a command that will delete the macro before
it saves?

Thanks.