The macros in this project are disabled

[picklefactory]

Morning all
Weird problem this morning, if anyone else has seen it before. Had a week off, came back in this morning and a spreadsheet I use every week, and have done for a couple of years now, suddenly won't function on ANY macro/VBA. There's quite a lot of VBA in the file and none of it is working now. I've checked all macro settings in Trust Centre, and everything is still fully enabled (Active X enabled, Macro Settings enabled, Protected View is disabled). I can't see anything different to usual.
I have 2 x back ups of this WB, and neither of them will function either now. Other WB's with VBA seem unaffected and work perfectly. I am confused as hell. Why would a perfectly functioning WB suddenly stop working and also the backups that haven't been touched in months?
Any thoughts please folks?

 

[bebo021999]

Is there any "Application.Timer" in your modules?

 

[picklefactory]

Hi bebo. No, I do use Application OnTime in other Wb's, but nothing in this one. Is there anywhere else in a specific file that macros can be disabled other than in Trust centre?

 

[picklefactory]

Just as an example, even this simple task at Workbook_Open will not function, if I run that manually I get the 'Macros in this workbook are disabled' message

Private Sub Workbook_Open()
UserForm1.Show
End Sub

 

[picklefactory]

Hmmm.... I have progress. I just saved the problem WB to my desktop and opened it from there and worked fine again. So maybe it's some sort of network issue as the usual WB is saved in a network folder.

 

[picklefactory]

I'll talk to our IT gang and see what they can come up with and post back later

 

[MARK858]

Is your Desktop listed as a Trusted location?

 

[picklefactory]

Hi Mark
No, but the standard location is. I've just been told one of my colleagues also had an issue with Excel macros last week. I'm waiting on our IT to update me now.
Cheers

 

[picklefactory]

Just an update on this one in case anyone else ever sees it.
Only just got it sorted. It seems to have been a network mapping issue. Excel wouldn't allow macros to run on any .xlsm on just one specific network drive. It also wouldn't allow me to add that drive as a trusted location due to 'Security settings' (As above, nothing had changed and all the usual macro, active x etc permissions were correct). I had to have our IT guys remap the drive to use the server name rather than the IP address that was set originally. Once we changed that, Excel then allowed trusted locations to be added and once the problem drive was added all macros are now functioning again. Very strange as I've been running this particular WB weekly for over 2 years, so we're wondering if there has been a MS update that has changed something.
Anyway, all back up and running.
Thanks again for the input folks.