Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Provide option to specify level of difficulty of the Question | Excel Discussion (Misc queries) | |||
Workbook level recalculation | Excel Programming | |||
Declarations Procedure and Duplicate Declarations | Excel Programming | |||
Application Level Events Question | Excel Programming | |||
Why, when I create workbook-level name does it jump it to Sheet-level ? | Excel Programming |