Macro ran yesterday doesn't run today


New Member
Apr 27, 2009
I have a file, that has some sheets that are protected at times and are open at other times (depends on who needs to use them). In it, there are two macros used to make the reports contained in the file update show current activity. The file is one of thirty that are set up the same way. All of them ran fine yesterday, today one of them is not running the update macros. Nothing changed, the other 29 are running far.

I've read in other posts on this forum that there is a potential problem with protected/encrypted files and a registry fix to get around the problem. However, the registry fix leaves the machine vulnerable to viruses, something I could get fired for (don't want that).

Has anyone found what is causing the issue? And, more importantly, a way to fix it without resorting to registry changes?

Here's what I've got:

Excel 2007 with macros fully enabled in the trust center and the files stored in a trusted location.

My company does run an anti-virus program; however, only one file is affected. I can make the registry change if I absolutely have to, but I'm not going to do it without IT's blessing (fat chance of that happening).

In the Developer/VB add-in, I can see that the names of the macros have changed as they did here:

I need a fix that works within the confines of normal MS Office structure, not registry fixes.

Can anyone help?

Thanks, Chris

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Watch MrExcel Video

Forum statistics

Latest member