Macro problem

S

scoutleader101

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?
 
A

Alan

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top