Hi,

I have played with this one for hours but its driving me mad..

I have read/write access to a workbook that I access via an internal
network. If It's not already open in write mode by one of the other 3
terminals that have the same read/write access, I can only open it in read
only until prompted that whoeven had it open in write mode has now closed
it. Every terminal can have it open in read only mode without it affecting
the write access.

The problem is that sometimes, the workbook gets left open in write mode and
forgotten about because its minimised or hidden behind another application,
meaning I have to go search for where its open in write mode and close it
myself.

What I want to do is create a timeout so that when the workbook has not had
focus for say 10 minutes, it saves any changes and closes.

This must only happen on the terminal that had the workbook in write mode
and those who had it in read only mode should be unaffected..

Good one Eh ?

Any ideas most welcome.