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 Security warning for non existant macro

You need to delete any modules as well, even though they are empty.

If you don't see any modules in the project explorer or you delete them and
still get the message, go to each sheet module, click in it, do Ctrl+A, hit
Delete, close it immediately. Do this for the ThisWorkbook module as well.
Save the workbook after making any changes.

--
Regards,
Tom Ogilvy

"Bradley" wrote in message
...
Hey all,
I've got an excel file that opens with the "Security Warning" dialog to
Enable or Disable Macros. I've gone to the Macro menu and deleted all
the macros, but I still get this Warning when I open the file.

How can I get rid of this?

TIA!

-b