View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Pete Pete is offline
external usenet poster
 
Posts: 193
Default Macros Error Message

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."

"Ron de Bruin" wrote:

Hi Pete

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

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Pete" wrote in message ...
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.