Purge file of VBA code and macros.
 

How do I purge an excel file of all macros? I still receive the macro
security warning when opening a file after I previously deleted all the
macros.

Purge file of VBA code and macros.
 

You have to delete any general/standard modules as well.

If you had code in the sheet/thisworkbook modules, you need to go to each of
them then do Ctrl+A, then delete, then close that module.

Now save the workbook.

--
Regards,
Tom Ogilvy

"CJ" wrote in message
...
How do I purge an excel file of all macros? I still receive the macro
security warning when opening a file after I previously deleted all the
macros.

Purge file of VBA code and macros.
 

You need to delete the Modules that contained the code.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"CJ" wrote in message
...
How do I purge an excel file of all macros? I still receive
the macro
security warning when opening a file after I previously deleted
all the
macros.