View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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.