If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Access 2003 Macro Security Warning | JAMCAR | New Users | 1 | November 23rd, 2005 12:47 AM |
Disable macro security for selected workbook | Jan | General Discussion | 1 | June 15th, 2005 07:56 AM |
Word has stopped access to the Endnote 6.0 with macro security | Tired and cranky student | General Discussion | 1 | April 27th, 2005 01:05 AM |
I can't change the macro security level | Julie | General Discussions | 3 | May 6th, 2004 03:53 PM |
change macro security level in Excel 97 | yufang | Setting up and Configuration | 2 | October 1st, 2003 02:26 AM |