hello,

I have problem with the sheet macro.

so I have this kind of sheet

sheet1public
public sub getinfo function 1 end sub
sheet2 public sub
public sub getroom function 2 end sub

workbook

private sub workbook_open()
sheet1.getinfo
sheet2.getroom
end sub

Module1 function
Module 2 Function

But I have a problem in sheet2 as all macro is executed in sheet1 not
in sheet2 why?

Ina