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

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

thanks Tom : D

Ina

What means " method or data member not found" do you thing Do i need
set my GetInfo into private sub

Ina

Make your procedure public

Public GetInfo( s as String)


end Sub

--
Regards,
Tom Ogilvy




"ina" wrote:

What means " method or data member not found" do you thing Do i need
set my GetInfo into private sub

Ina

Thanks, Can I also make a function public?