Macro Security
 

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.

Macro Security
 

Hi,

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

Cheers,
Shane Devenshire

"Dave W" wrote:

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.