Excel Blocking Macros...on just one file in folder

[Match12]

I have hundreds of files in a folder that all use the same set of macros. The folder has been added to "Trusted Locations" and setting are set to "Enable All Macros".
The Excel gods have decided to block the macros on one file.
I copied the file out of the folder(macros were still block in new location -again a trusted one), stripped the macros, saved, added the macros back in, saved and closed
All macros fired properly when I open the file.
I then saved the file back to the original location. Saved and Closed. When I reopened the file, again the macros were blocked.
I am lost...

 

[Match12]

Did you read post 2 about API code? I just can't see a response to it

No API Code...same macros in about 100 files..this is the only one acting like this

 

[MARK858]

What happens when you create a copy of the file and save it as an .xlsb

 

[jkpieterse]

Other calls to external dll's, like winmgt?

 

[Match12]

What happens when you create a copy of the file and save it as an .xlsb

Other calls to external dll's, like winmgt?

Saving it as a .slsb did not help..

There are no external calls.


But..not sure what I did (i tried so many things this morning...) but it now seems to be working

And looking back through my notes I see I fixed this same file about a month ago...(not sure what I did then either!)

I will mark this one solved

 

[Joe4]

I will mark this one solved

Note that feature is not to "mark a thread as solved", but rather to indicate which post actually contains the solution.

Since you are not really sure how it was fixed (it just started working again), I unmarked that post, because it doesn't actually contain any solution.