Hi Rob,
I need some help with the use of 'ontime' and the passing of the value of a variable from thisworkbook to a macro. I've posted the code and details on
http://www.excelforum.com/excel-prog...o-log-off.html.
Basically, I am trying to create and Auto log off option so that the workbook closes if no entry has been made for say 10 secs (5 mins in practice).
I need to know 1. if my way of declaring a variable Public is correct or required at all.
2.I need to know how to close any instance of 'ontime' that happens to be running, except the most recent one.
Since I got only one reply that was not really useful, on posting this on the site and I'm not sure if its because I've posted in the wrong category, I'm contacting you directly for advice. Kindly view the thread mentioned above. Hope you can help.
Thanks in advance,
Bala
