ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Macro Enable/Disable Pop-Up Warning (https://www.excelbanter.com/excel-discussion-misc-queries/261032-macro-enable-disable-pop-up-warning.html)

juamig

Macro Enable/Disable Pop-Up Warning
 
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?

Dinomatic

Macro Enable/Disable Pop-Up Warning
 
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?


juamig

Macro Enable/Disable Pop-Up Warning
 
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?



All times are GMT +1. The time now is 04:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com