Re: Public Variable in ThisWorkbook



Thank you.

"Chip Pearson" <chip@xxxxxxxxxxxx> wrote in message
news:OmZwr6rPFHA.3988@xxxxxxxxxxxxxxxxxxxxxxx
> 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" <DklineCLUChFC@xxxxxxxxxxx> wrote in message
> news:usgYh3rPFHA.248@xxxxxxxxxxxxxxxxxxxxxxx
> >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?
> >
> >
>
>


.