Static global varibale - where tu put it?

M

Mac

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?
 
J

joel

Use a Dim statement in a module or Class module out side any sub o
function


Dim A
sub Test
A = 5
end tes
 
Top