Macro Security

[Dave W]

I ran a macro successfully in my spreadsheet saved it as Macro Enabled. When
I came back into the spreadsheet the macros were disabled. When I went the
macro security the box that allows to change to enabled was locked(could
change options). Any idea what is locking this up. I also noticed an
exclamation point on the excel icon for the file.

 

[Shane Devenshire]

Hi,

When you opened the file did you click the Opions choice on the Security
Bar? and say Enable contents?

Cheers,
Shane Devenshire