Enable/Disable Macro Pop-Up

[juamig]

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?

 

[Bob I]

See Help, macro setting

Change macro security settings in Excel

 

[juamig]

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?

 

[Gord Dibben]

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

 

[JLatham]

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.

 

[Bob I]

As J Latham says, it's not the big one that 2003 had, just at the top of
the worksheet.