Thread: workbook_open execute macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 6,953
Default workbook_open execute macro
Private Sub Workbook_Open()

Sheet1.GetInfo "John"
Sheet2.GetInfoRoom

End Sub

--
Regards,
Tom Ogilvy


"ina" wrote:

hello,

I would to open my macro and automatically execute my macro in the
sheet1 and another in sheet2

Private Sub Workbook_Open()

Sheets("Clients").GetInfo "John"
Sheets("Room29.GetInfoRoom

End Sub

But doesn't work?

Ina


Reply With QuoteReply With Quote