Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How turn off macro security question for workbook with no marcos? | Excel Discussion (Misc queries) | |||
Closing File Error | Excel Discussion (Misc queries) | |||
how to raise the Macro security level in a product I can't execute | Excel Discussion (Misc queries) | |||
Formulae, conditional formatting & macro security | Excel Discussion (Misc queries) | |||
Security in macro | Excel Discussion (Misc queries) |