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
.
|