This worked fine. I found it best to create a new module and put the public
variables there. As you said, it doesn't work if you put the public
variables in the same module.

Thanks again!!

Bob Phillips wrote in message
...
Not ThisWorkbook, as that is a class module. Put it in a general code
module.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"OJ" wrote in message
oups.com...
Hi,
How about a global boolean variable that sets the value of the checkbox
on form loading and gets set by the checkbox on unloading? You could
set it in ThisWorkbook module (I think)....

Hth,
OJ