Macros disabled when trying to open and run from another workbook

[McGran]

The following code opens a workbook called 'Move Files' and runs the macro called 'MoveFiles'

Option Explicit
Sub Open_MoveFiles()
Dim wb As Workbook

Set wb = Workbooks.Open("\\[Folder hierarchy]\Move Files.xlsm")

Application.Run "'" & wb.Name & "'! MoveFiles", 1
wb.Save
wb.Close
Set wb = Nothing

ThisWorkbook.Saved = True
Application.Quit

End Sub

Until yesterday it was working perfectly well for me on 2010 and still works for other users on 2007, 2010 and 365. It no longer works for me though, returning the error

My macros are enabled (unchanged from when the file ran correctly) but it fails when I run on either 2010 or 365. Also any attempt to manually run the 'MoveFiles' macro from this instance of the file also fails, but if I close it down and re-open the 'Move Files' workbook I can successfully run the macro.

It appears as if the call to open the 'Move Files' workbook is disabling the macros for that instance.

Any ideas what is going on and how to resolve it?

 

[ranman256]

You may need to change the macro settings in OPTIONS.
Allow all macros.

 

[McGran]

Thanks for replying.

It's already set to allow all.

 

[RoryA]

Try adding:

application.automationsecurity = msoAutomationSecurityLow

before the line that opens the workbook.

 

[McGran]

Legend.

I'm still no closer to understanding why it suddenly stopped working but it works, and that's good enough for me.

Cheers

 

[RoryA]

I suspect something got updated on your computer that altered that setting to disable macros when you open other workbooks in code.

 

[McGran]

Yeah, seems that way.

Thanks again