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

See answer to your previous posting of this question.

--
Regards,
Tom Ogilvy


"ina" wrote:

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

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