Thread: call multiple macros in workbook_open?
View Single Post
  #7  
Old 03-09-2006, 10:29 PM
Desert Piranha Desert Piranha is offline
Valued Forum Contributor
  
Join Date: 20 Nov 2005
Posts: 256
Desert Piranha is becoming part of the community
Quote:
Originally Posted by slimswol
Any ideas on what to do next to run / call multiple macros when opening the excel document?
Hi,
You mean something like this?

Private Sub Workbook_Open()
Call Macro1
Call Macro2
Call Macro3
End Sub

Sub Macro1()
MsgBox "This is #1"
End Sub

Sub Macro2()
MsgBox "This is #2"
End Sub

Sub Macro3()
MsgBox "This is #3"
End Sub
__________________
Thx
Dave
"The game is afoot Watson"
Reply With Quote