Call a macro in my personal.xls

[Greg Rivet]

What is the syntax for calling a macro that resides in my personal.xls. TIA

 

[Robert Rosenberg]

Here's one example:

Sub CallPersonalMacro()
Application.Run "Personal.xls!Test"
End Sub

Where:

"Test" is the name of the macro

 

[Greg Rivet]

Bob, thank you very much................

Greg

Here's one example:

Sub CallPersonalMacro()
Application.Run "Personal.xls!Test"
End Sub

Where:

"Test" is the name of the macro