Thread: Macro problem
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Alan Alan is offline
external usenet poster
 
Posts: 492
Default Macro problem

Although you have no macros listed, if there is one or more empty modules
shown on the left of the VB editor, these will generate the macro warning.
Delete these and the problem should stop.
Regards,
Alan.
wrote in message
...
I consistently get a macro warning for a specific file when I attempt
to open it. My Security setting is set to High.

While the file is open I press Alt F8 to bring up the macro box but
the file has no macros listed. I'm searching All Open Workbooks. I
appear to have VBA installed. Within the Tools|Addins window I see
Analysis ToolPak, Analysis ToolPak VBA and Internet Assistant VBA
checked.

What am I missing?