Hi guys,

I have a number of workbooks which various people update. These are
accessed by a Read only menu workbook which people have open. The problem
I'm having is that people tend to leave these workbooks open on their
computer, thus rendering them uneditable by others.
I tried the ontime timeout code but while this worked fine with one
workbook, if two workbooks start timing out simultaneously then I've found
that they interfere with each other.

What I want to know is if there is a way to save & close a workbook open on
someone else's computer.
I've tried this already by the following means.
The Read Only menu workbook, which everyone uses to open the workbooks, runs
a bit of code every 30 seconds. This checks a folder for text files and
compares the file names of those text files with the file names open editable
workbooks. If they match then the workbook is saved and closed and the text
file deleted.
So in order to save and close a workbook I simply create a text file in this
folder with the same name. This works for me but not with others.

All files are located on a networked drive.

Many thanks in advance.