Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Security Warning | Excel Discussion (Misc queries) | |||
Macro security warning | Excel Discussion (Misc queries) | |||
Fault macro security warning | Excel Discussion (Misc queries) | |||
Why am I getting 2nd macro security warning? | Excel Discussion (Misc queries) | |||
Macro/Security Warning | Excel Discussion (Misc queries) |