--These variables are to be dimensioned at the top of a module like
Public blnSheet1 as Boolean

--For a clear picture on this refer the below link
http://www.ozgrid.com/VBA/variable-scope-lifetime.htm


--
Jacob


"Mac" wrote:

Hello,
I need to initialize a couple of objects on a sheet just once upon
Sheet.Activate event; I'd use a bool varibale as a semaphor so that further
inits would be prevented if a user returned to that sheet from another one
and this semaphor would have been set to true. Now - where should I put this
variable for it to retain its value throughout the 'lifetime' of the whole
workbook?