software

I started a worksheet in Excel 2003 and saved it. When I opened it I
received the Macro Security warning. I checked and my macro security was set
to High, so I set it to Medium. Now every time I open this worksheet Excel
asks if I want to enable or disable macros. I enabled the macros in my new
worksheet, then went to Tools, Macro, Macros, and there are no macros in
this worksheet or in any open templates.

Why would Excel give me the security warning to enable/disable macros if
there are no macros in the worksheet? Are there 'hidden' macros that are not
listed in the macro dialog?

My system is fully patched, with all MS Office patches. It is fully
up-to-date.

I am familiar with all of this in Word, but I am a brand new spreadsheet
user and this is the first time I have come across this with Excel. I am
troubled by needing to enable macros that do not appear to be present.

An education would be appreciated!

Sincerely,
Gene
Debra Dalgleish shows how to clean up all the remnants of macros:
www.contextures.com/xlfaqMac.html#NoMacros
Gene wrote:
gt;
gt; I started a worksheet in Excel 2003 and saved it. When I opened it I
gt; received the Macro Security warning. I checked and my macro security was set
gt; to High, so I set it to Medium. Now every time I open this worksheet Excel
gt; asks if I want to enable or disable macros. I enabled the macros in my new
gt; worksheet, then went to Tools, Macro, Macros, and there are no macros in
gt; this worksheet or in any open templates.
gt;
gt; Why would Excel give me the security warning to enable/disable macros if
gt; there are no macros in the worksheet? Are there 'hidden' macros that are not
gt; listed in the macro dialog?
gt;
gt; My system is fully patched, with all MS Office patches. It is fully
gt; up-to-date.
gt;
gt; I am familiar with all of this in Word, but I am a brand new spreadsheet
gt; user and this is the first time I have come across this with Excel. I am
gt; troubled by needing to enable macros that do not appear to be present.
gt;
gt; An education would be appreciated!
gt;
gt; Sincerely,
gt; Gene

--

Dave Peterson

Hi!

See this:

contextures.com/xlfaqMac.html#NoMacros

Biff

quot;Genequot; gt; wrote in message
...
gt;I started a worksheet in Excel 2003 and saved it. When I opened it I
gt;received the Macro Security warning. I checked and my macro security was
gt;set to High, so I set it to Medium. Now every time I open this worksheet
gt;Excel asks if I want to enable or disable macros. I enabled the macros in
gt;my new worksheet, then went to Tools, Macro, Macros, and there are no
gt;macros in this worksheet or in any open templates.
gt;
gt; Why would Excel give me the security warning to enable/disable macros if
gt; there are no macros in the worksheet? Are there 'hidden' macros that are
gt; not listed in the macro dialog?
gt;
gt; My system is fully patched, with all MS Office patches. It is fully
gt; up-to-date.
gt;
gt; I am familiar with all of this in Word, but I am a brand new spreadsheet
gt; user and this is the first time I have come across this with Excel. I am
gt; troubled by needing to enable macros that do not appear to be present.
gt;
gt; An education would be appreciated!
gt;
gt; Sincerely,
gt; Gene
gt;
Dave,

Thank you. That fixed the problem.

Sincerely,
Genequot;Dave Petersonquot; gt; wrote in message
...
gt; Debra Dalgleish shows how to clean up all the remnants of macros:
gt; www.contextures.com/xlfaqMac.html#NoMacros
gt;
gt;
gt;
gt; Gene wrote:
gt;gt;
gt;gt; I started a worksheet in Excel 2003 and saved it. When I opened it I
gt;gt; received the Macro Security warning. I checked and my macro security was
gt;gt; set
gt;gt; to High, so I set it to Medium. Now every time I open this worksheet
gt;gt; Excel
gt;gt; asks if I want to enable or disable macros. I enabled the macros in my
gt;gt; new
gt;gt; worksheet, then went to Tools, Macro, Macros, and there are no macros in
gt;gt; this worksheet or in any open templates.
gt;gt;
gt;gt; Why would Excel give me the security warning to enable/disable macros if
gt;gt; there are no macros in the worksheet? Are there 'hidden' macros that are
gt;gt; not
gt;gt; listed in the macro dialog?
gt;gt;
gt;gt; My system is fully patched, with all MS Office patches. It is fully
gt;gt; up-to-date.
gt;gt;
gt;gt; I am familiar with all of this in Word, but I am a brand new spreadsheet
gt;gt; user and this is the first time I have come across this with Excel. I am
gt;gt; troubled by needing to enable macros that do not appear to be present.
gt;gt;
gt;gt; An education would be appreciated!
gt;gt;
gt;gt; Sincerely,
gt;gt; Gene
gt;
gt; --
gt;
gt; Dave Peterson
Biff,

Thank you. That fixed the problem.

Sincerely,
Genequot;Biffquot; gt; wrote in message
...
gt; Hi!
gt;
gt; See this:
gt;
gt; contextures.com/xlfaqMac.html#NoMacros
gt;
gt; Biff
gt;
gt; quot;Genequot; gt; wrote in message
gt; ...
gt;gt;I started a worksheet in Excel 2003 and saved it. When I opened it I
gt;gt;received the Macro Security warning. I checked and my macro security was
gt;gt;set to High, so I set it to Medium. Now every time I open this worksheet
gt;gt;Excel asks if I want to enable or disable macros. I enabled the macros in
gt;gt;my new worksheet, then went to Tools, Macro, Macros, and there are no
gt;gt;macros in this worksheet or in any open templates.
gt;gt;
gt;gt; Why would Excel give me the security warning to enable/disable macros if
gt;gt; there are no macros in the worksheet? Are there 'hidden' macros that are
gt;gt; not listed in the macro dialog?
gt;gt;
gt;gt; My system is fully patched, with all MS Office patches. It is fully
gt;gt; up-to-date.
gt;gt;
gt;gt; I am familiar with all of this in Word, but I am a brand new spreadsheet
gt;gt; user and this is the first time I have come across this with Excel. I am
gt;gt; troubled by needing to enable macros that do not appear to be present.
gt;gt;
gt;gt; An education would be appreciated!
gt;gt;
gt;gt; Sincerely,
gt;gt; Gene
gt;gt;
gt;
gt;