Excel 2007 (12.0.6214.1000) Enable Macro Error after Macros Enabled and Restarted

[BrooksTech]

After attempting to run a verifiable-working macro, I now keep getting this 'You Need to Enable Macros and Restart Excel' message after going into "Developer, Security" and verifying that macros are already enabled for that Worksheet. I'll de-select and then re-select "Enable" to try to shake it up, then close and restart Excel to no avail. Couldnt find any other answers on this issue in the MS KB.

 

[Andrew Poulsom]

What do you have checked under Macro Settings on the Trust Center dialog?

 

[BrooksTech]

It says ENABLE (last box) and also Trust Access to VBA BOTH checked. Im thinking its hung up on a Cookie or a Registry Setting. Im also gonna try to copy the Macro to a New Worksheet while waiting for any other suggestions. Thanks again.

 

[BrooksTech]

Copying the Macro to a new Worksheet worked. Apparently there was a bug in my old one. Thanks anyways.