Macro Settings, Am I missing something?

[sandcounter]

Microsoft Office Excel 2007, Windows XP Service Pack 3

Despite having "Enable all macros (. . ." selected in the Trust Center. I still get a message that the macros have been disabled. All my other spreadsheets seems to work fine.
I have opened, changed settings back and forth, closed, etc.
I have tried exporting and importing the macros back into the workbook.

I notice that macros used to be listed by macroName, now they are listed as 'workbookName'!macroName in the macro dialog box. Does this make a difference? Why would this change?

The macros in this spreadsheet have worked for 97 days straight on the same computer with no obvious changes to the macros or settings. Is there another setting that I am missing?

Is this a bug, or user error? Thanks in advance, any help is much appriciated.

 

[Chris.DaRockman]

nocturnal028, were you ever able to determine what happened? I have just run in to the same issue. Macros enabled and they worked yesterday, today...no go. I see the same name change as mentioned above too. The sheets are alternately protected and not protected, but never encrypted.

 

[nocturnal028]

I used the registry fix to get around my problem. I never did determine the real cause. I have since wiped my machine and have also upgraded to Office 2010... the problem just never re-surfaced to give me an opportunity to dig deeper into the issue to find the real cause.

It was strange how it happened and I still have users in the spreadsheet almost daily with no issues. I would try the registry fix if i were you but if that doesn't help you then I'm not sure what else to suggest. It definitely had me stumped.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
Sorry I can't be more help! Good luck!