Try this Shane

http://www.erlandsendata.no/english/.../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.


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Shane Coughlan" wrote in message ...
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.