Security warning for non existant macro
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 |
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 |
Security warning for non existant macro
Tools|Macro|Visual Basic Editor
Delete any modules shown in the project window. Double click on each sheet and the workbook entry in the project window; for each, Edit|Select All and press the delete key. The macro warning is not very discriminating. Codeless modules, or even a space character in a code page will trigger the warning. Jerry Bradley wrote: 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? |
Security warning for non existant macro
They may be in the Sheets try checking each sheet and "ThisWorkbook" modules.
"Bradley" wrote: 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 |
Security warning for non existant macro
Bradley wrote:
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 Thanks all! That did it. -b |
All times are GMT +1. The time now is 02:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com