Hi VanS,

Worksheet and ThisWorkbook module are private, thus the message regarding
the variable in the other code module.

To make a variable global, place it in a standard module, outside any
procedures. This is usually done in a MGlobals module (if you use one), at
the top in the Declarations section. Declaring it Public makes it accessible
to all components of your project while the project is open.

HTH
Regards,
GS

"VanS" wrote:

Hello,
Trying to meet deadline but couldn't find anything in MS documentation re
making variable declarations at the Workbook level under ThisWorkbook. If I
make such a variable declaration there with Option Explicit and Public, will
it be available to all Worksheets and modules code? I created a boolean such
var and one worksheet code module recognized it but another cried "Variable
Not Defined".
I was trying to avoid putting it into a code module if possible.
Thanks, God bless
Van