How to activate a user macro within a workbook from another Excel worksheet ?
See the following example:
In Workbook #1 include the following procedure
Sub quicktest()
Application.Run ("Book2!WB2")
End Sub
In Workbook #2 create the procedure "WB2"
Sub WB2
MsgBox "This is how"
End Sub
The procedure in Workbook #1 calls the procedure in
Workbook #2, which is what I understand you are trying to
accomplish.
Bill
Quote:
>-----Original Message-----
>I want to activate a macro within a worksheet by
referring to its name from
Quote:
>another Excel worksheet by VBA-code. How can I achieve
that ?
>Oscar
>.
