View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
VanS[_2_] VanS[_2_] is offline
external usenet poster
 
Posts: 60
Default Question re Workbook level declarations

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