Thread: Running macro on open of workbook?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bearacade[_11_] Bearacade[_11_] is offline
external usenet poster
  
Posts: 1
Default Running macro on open of workbook?

Put this in ThisWorkbook in VBA

Private Sub Workbook_Open()

Call whateveryourmacroiscalled()
MsgBox ("Macro Finished")

End Su

--
Bearacad

-----------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...fo&userid=3501
View this thread: http://www.excelforum.com/showthread.php?threadid=55193

Reply With QuoteReply With Quote