Macro ran yesterday doesn't run today

Chris.DaRockman

New Member
Joined
Apr 27, 2009
Messages
9
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 fine...so 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: http://www.mrexcel.com/forum/showthread.php?t=343191

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

Threads
1,118,507
Messages
5,572,568
Members
412,470
Latest member
nirortal
Top