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

[Tom Ogilvy]

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
>
>

[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