exceldvlpr
New Member
- Joined
- May 22, 2002
- Messages
- 20
How do I get a particular workbook to launch another work book on startup? I currently have a command button that will do this, but how do I make it so when I open one, the other will automatically open as well and stay in the background (inactive). Here is my current macro associated with the command button that does what I explained above.
Sub launch()
launch Macro
Macro recorded 10/3/2002 by exceldvlpr
ChDir "C:MiscQD Form"
Workbooks.Open Filename:="C:MiscQD FormQD Mnthly Smry.xls"
Windows("QD Form.xls").Activate
Range("C12:P13").Select
End Sub
Sub launch()
launch Macro
Macro recorded 10/3/2002 by exceldvlpr
ChDir "C:MiscQD Form"
Workbooks.Open Filename:="C:MiscQD FormQD Mnthly Smry.xls"
Windows("QD Form.xls").Activate
Range("C12:P13").Select
End Sub