Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Gene
 
Posts: n/a
Default Macro security

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


  #2   Report Post  
Posted to microsoft.public.excel.newusers
Dave Peterson
 
Posts: n/a
Default Macro security

Debra Dalgleish shows how to clean up all the remnants of macros:
http://www.contextures.com/xlfaqMac.html#NoMacros



Gene wrote:

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


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Biff
 
Posts: n/a
Default Macro security

Hi!

See this:

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

Biff

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



  #4   Report Post  
Posted to microsoft.public.excel.newusers
Gene
 
Posts: n/a
Default Macro security

Dave,

Thank you. That fixed the problem.

Sincerely,
Gene


"Dave Peterson" wrote in message
...
Debra Dalgleish shows how to clean up all the remnants of macros:
http://www.contextures.com/xlfaqMac.html#NoMacros



Gene wrote:

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


--

Dave Peterson



  #5   Report Post  
Posted to microsoft.public.excel.newusers
Gene
 
Posts: n/a
Default Macro security

Biff,

Thank you. That fixed the problem.

Sincerely,
Gene


"Biff" wrote in message
...
Hi!

See this:

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

Biff

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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How turn off macro security question for workbook with no marcos? Dewy Cheatum & Howe Excel Discussion (Misc queries) 2 December 9th 05 10:14 PM
Closing File Error jcliquidtension Excel Discussion (Misc queries) 4 October 20th 05 12:22 PM
how to raise the Macro security level in a product I can't execute vfstevenson Excel Discussion (Misc queries) 0 September 15th 05 09:48 PM
Formulae, conditional formatting & macro security Kevin Lucas Excel Discussion (Misc queries) 7 March 15th 05 01:10 PM
Security in macro Pam Coleman Excel Discussion (Misc queries) 1 February 24th 05 10:41 PM


All times are GMT +1. The time now is 05:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"