Hi,
I posted something similar previously but I wasn't able to solve the problem I had.
For example I have the following workbook up "run_Macro1.xlsm" and the following code in Module1 of the workbook.
Sub run_Macro_1()
Worksheets("Sheet1").Range("A1").Value = "I just ran macro 1"
End...