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?

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?

Thanks very much. Deleting the empty modules did indeed do the trick.


On Mar 4, 4:20*pm, "Alan" wrote:
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,
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?- Hide quoted text -

- Show quoted text -