Run a macro in another book

twistinginthewind

Board Regular
Joined
Jun 25, 2003
Messages
119
I'm sure I'm going to kick myself when i see the answer to this but...

How can i have a macro in one workbook call a macro from another workbook?
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Ziggy

Active Member
Joined
Feb 15, 2002
Messages
337
PLace this in the 1st macro...

Application.Run "Book1!Macro1"
 

Watch MrExcel Video

Forum statistics

Threads
1,113,859
Messages
5,544,700
Members
410,630
Latest member
Maggie28
Top