Running a Macro on another worksheet

[Paul_Hossler]

Paul_Hossler
What transpired before that is that the user had selected the other workbook, so the other remote workbook was selected and therefore became the Active Workbook.
Hope that makes sense.

I sort of follow


From post #1 ..

Running a Macro on another worksheet (Assume you meant 'Workbook')

I am trying to run a Macro on a different WorkBook.

It wasn't clear to me (at least) which WB had the macro and which WB the macro was intended to operate on

Since this works, I assumed that the WB 'Search Database 2025 test.xls' contained the macro RedFont

This works: Application.Run ("'Search Database 2025 test.xls'!RedFont")

What I missed was some how activating the macro containing WB, either manually or in code

Workbooks("'Search Database 2025 test.xls'").Activate

which as you said then makes Search Database 2025 test.xls the ActiveWorkbook in

 ol2 = ActiveWorkbook.Name
Workbooks(ol2).Application.Run ("!RedFont")