424 Error within a simple application.run procedure
I'm simply just trying to run a macro which applies a list of macros from another workbook. Thought this code worked already when I applied it a couple weeks ago but something changed I think.
I clicked a button which runs the CALLMacros macro from the local workbook.
Here's my code:
Sub CALLMacros()
Application.Run (MacroBooks.xlsm!DIRECTCOMPTRD)
Application.Run (MacroBooks.xlsm!DIRECTNONCOMPTRD)
Application.Run (MacroBooks.xlsm!NONCOMP2)
Application.Run (MacroBooks.xlsm!NONCOMPTRD)
Application.Run (MacroBooks.xlsm!TOTALDIRECTEXPTRD)
End Sub
|