I want to declare some public variables as soon as I open the workbook. Can
I do that in "ThisWorkbook" or do I need to put it in a module and have
"ThisWorkbook" Open event call a routine to set the public variables?

If the variables are going to be used in procedures outside the
ThisWorkbook module, you should declare them in the declarations
section of a regular code module, and initialize them in the Open
event procedure.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"DRKML" wrote in message
...
I want to declare some public variables as soon as I open the
workbook. Can
I do that in "ThisWorkbook" or do I need to put it in a module
and have
"ThisWorkbook" Open event call a routine to set the public
variables?

Thank you.

"Chip Pearson" wrote in message
...
If the variables are going to be used in procedures outside the
ThisWorkbook module, you should declare them in the declarations
section of a regular code module, and initialize them in the Open
event procedure.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"DRKML" wrote in message
...
I want to declare some public variables as soon as I open the
workbook. Can
I do that in "ThisWorkbook" or do I need to put it in a module
and have
"ThisWorkbook" Open event call a routine to set the public
variables?