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?