View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mac Mac is offline
external usenet poster
 
Posts: 213
Default Static global varibale - where tu put it?

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?