sheets macro

[ina]

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

 

[Guest]

See answer to your previous posting of this question.

 

[ina]

yes but doesn't work this is the problem I would like to call my file
from vbscript and it is not executing my code; and even if I launch it
from excel it is activate only sheet without executing the code

Ina