This topic has been already mentioned, however without a solution. I have a very simple Macro calling other workbooks and their macros to execute:
Sub Execute()
Workbooks.Open Filename:="C:Beta.xlsm"
Application.Run "C:Beta.xlsm!Macro"
Workbooks.Open Filename:="C:Alpha.xlsm"
Application.Run "C:Alpha.xlsm!Macro1"
ThisWorkbook.SaveChanges = False
Application.Quit
End Sub
The problem is that, now I receive an error 1004
with a message: Cannot run the macro The macro may not be available or all macros may be disabled.
PS. I have already enabled Macros and ticked the box in Trust Centre (still having error).
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…