Closing workbooks through macro

[Shane Coughlan]

I would like to be able to close a workbook (possibly with
a macro) after it has been open for a specific period of
time.
There are a number of people in the office who access the
same files on different PC's and sometimes people leave
the files open so that other users only have 'read only'
access

Any and all help is appreciated

Rgds
Shane.

 

[Ron de Bruin]

Try this Shane

http://www.erlandsendata.no/english/downloads/workbooks.htm

Close idle workbooks
This example workbook contains macros that might be useful if you have problems with
users that never remembers to close workbooks they share with other users.