Macros Error Message

[Pete]

HMessage : Macros are disabled because the secirity level is set to High. To
run the macros, lower the security setting and verify the marcos are signed
and trusted.

Problem is that this only happens when I open one specific worksheet (not
any others). Also, I never use macros. If I go into tools, there are no
marcros installed. Virus checked file - no bugs. ,,,,,, .....

I just click OK and go on using worksheet.

Any knowledge as to why would be appreciated.

 

[Ron de Bruin]

Hi Pete

If there is a empty macro module Excel will think that there is code.

See
http://www.contextures.com/xlfaqMac.html#NoMacros

 

[Pete]

Ron:

Thanks!!!!!! You were able to do what no one has been able to in many
years. You are an MVP.

When I reviewed the link you provided, the solution was there. Somehow
there was VB code assigned to the sheet (Right click on any sheet tab and
choose View Code, to open the Visual Basic Editor.) It was non-invasive and
I have no idea how it was assigned it to the sheet and why this method is the
only way to find it vs not under Tools / Macros. The link you provided
stated that "A macro has been added and then removed, leaving an empty
module. Empty modules trigger the macro query, as does an actual macro."