Use of 'on time' to kick inactive users

[TKCZBW]

A fairly hackneyed question this, with quite a lot of literature available on the web, but nothing that answers my specific question.

I use the 'on time' function to kick users out of a shared workbook after 30 minutes of inactivity (i.e. no cells updated). Technically it works, as it does kick out the users.

However the time after which it does so seems to bear no relation to the time I have instructed. Sometimes shorter, sometimes longer! If it is was always longer, I would be happy that there is an error in my code somewhere (i.e. the time value is resetting on an unexpected event that I need to find and alter). But shorter: that really stumps me.

I'm sure it's something rather straightforward, but I'd be most grateful for any ideas!

[adyteo]

probably if you show us the code, we may be able to help

[TKCZBW]

I took the code verbatim from: http://excelribbon.tips.net/T008192_...nactivity.html, as prima facie it did exactly what I wanted with no tinkering. A fairly bad habit I know, to use code one doesn't fully understand!

Please Login or Register  to view this content.

[mc84excel]

Sometimes shorter, sometimes longer! If it is was always longer, I would be happy that there is an error in my code somewhere (i.e. the time value is resetting on an unexpected event that I need to find and alter). But shorter: that really stumps me.

I'm sure it's something rather straightforward, but I'd be most grateful for any ideas!

Only ideas that occur to me:
Longer is due to the existing event procedures triggering without you realising. (Try putting a MsgBox in these event procedures while you are testing - then you can see whenever these events fire)
Shorter is due to a workbook change that you don't have an event procedure already set up to reset the timer.

[TKCZBW]

For the 'longer', I agree.

For the shorter, by the very nature of the NOW + ("00:30:00"), it shouldn't kick in anything before 30 mins after workbook open.

Perhaps I should have made myself clearer, but I test it from a single changed cell immediately after workbook-open. Once I could get it to work from that, then I could ensure all the reset conditions function properly.

[mc84excel]

For the shorter, by the very nature of the NOW + ("00:30:00"), it shouldn't kick in anything before 30 mins after workbook open.

It wasn't clear from the OP. I thought that it closed on you less than 30 minutes after you triggered an event.

I test it from a single changed cell immediately after workbook-open. Once I could get it to work from that, then I could ensure all the reset conditions function properly.

Hmmm. Maybe it wasn't the timer closing the WB, maybe it just crashed?!

[TKCZBW]

Nope, definitely the timer as I got it to run a message box before close, to make sure it wasn't an unrelated cause of closure.

The plot thickens!