Thread: not use
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Mark[_17_] Mark[_17_] is offline
external usenet poster
 
Posts: 95
Default not use

Hi Harald,

How will be in not used userform?
Coridially
Mark


-----Original Message-----
Hi Mark

Use a global Date variable and set it to Now on all sorts

of events
(Worksheet_change, Worksheet_Selectionchange,

Worksheet_Activate, ... ).
Then have a macro that for certain intervals checks if

this variable is more
than 20 minutes old.

HTH. Best wishes Harald

"Mark" skrev i melding
...
I looking for code - if activeworkbook not use for 20
minutes then stuff ..

Please advise I would be very grateful.

Regards
Mark



.