Enable/Disable Macro Pop-Up
in [General]
|
From: juamig on 9 Apr 2010 11:59 In the older version of Office when you opened an excel or other office document that had a macro in it - you would get a pop up and the opportunity to enable or disable it. Is there a way to get that same pop-up in 2007?
From: Bob I on 9 Apr 2010 12:09 See Help, macro setting Change macro security settings in Excel juamig wrote: > In the older version of Office when you opened an excel or other office > document that had a macro in it - you would get a pop up and the opportunity > to enable or disable it. Is there a way to get that same pop-up in 2007? >
From: juamig on 9 Apr 2010 14:39 Right, someone else told me the same thing but this does not offer the option to have the pop-up. the pop-up is what I'm interested in. Am I missing something? "Bob I" wrote: > See Help, macro setting > > Change macro security settings in Excel > > juamig wrote: > > In the older version of Office when you opened an excel or other office > > document that had a macro in it - you would get a pop up and the opportunity > > to enable or disable it. Is there a way to get that same pop-up in 2007? > > > > . >
From: Gord Dibben on 9 Apr 2010 18:29 If you "disable with notification" and the workbook is opened from a location that is not a "trusted location" then you will get notification in a warning bar across the top of the sheet. Says macros have been disabled and gives you an "Options" button. Gord Dibben MS Excel MVP On Fri, 9 Apr 2010 11:39:02 -0700, juamig <juamig(a)discussions.microsoft.com> wrote: >Right, someone else told me the same thing but this does not offer the option >to have the pop-up. the pop-up is what I'm interested in. Am I missing >something? > >"Bob I" wrote: > >> See Help, macro setting >> >> Change macro security settings in Excel >> >> juamig wrote: >> > In the older version of Office when you opened an excel or other office >> > document that had a macro in it - you would get a pop up and the opportunity >> > to enable or disable it. Is there a way to get that same pop-up in 2007? >> > >> >> . >>
From: JLatham on 10 Apr 2010 01:10
But if you're looking for the big Excel 2003 type notification in the middle of the display, well that's gone in 2007 -- you get the hardly noticeable bar at the top and that's all you get. "juamig" wrote: > Right, someone else told me the same thing but this does not offer the option > to have the pop-up. the pop-up is what I'm interested in. Am I missing > something? > > "Bob I" wrote: > > > See Help, macro setting > > > > Change macro security settings in Excel > > > > juamig wrote: > > > In the older version of Office when you opened an excel or other office > > > document that had a macro in it - you would get a pop up and the opportunity > > > to enable or disable it. Is there a way to get that same pop-up in 2007? > > > > > > > . > > |