Prev: How to retrieve the sheet name?
Next: I closed an excel file without saving the changes. Can I retrieve
From: juamig on 8 Apr 2010 17:51 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: Dinomatic on 8 Apr 2010 18:06 Try the following... Click Trust Center, click Trust Center Settings, and then click Macro Settings. Then "Disable all macros with notification". "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 8 Apr 2010 18:37
Ok, this option is already checked and all this does is give you a warning in one of the bars up above, not obvious at all. Is there any way to get the pop-up upon opening a document like it did in 2003? "Dinomatic" wrote: > Try the following... > > Click Trust Center, click Trust Center Settings, and then click Macro > Settings. > Then "Disable all macros with notification". > > "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? |