Hi, I need your help to solve a scope problem.

I want a variable that can be accessed in "ThisWorkBook", and other
Sheets.

I tried to create a public variable in "ThisWorkBook", but I got a
undefined error, when tried to use it at other sheets module....

Also, How can I create a procedure in "ThisWorkBook" and can be
accessed in other sheets.


Thanks for your help.

Johnny.