Closing workbooks through macro
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. |
Closing workbooks through macro
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. |
All times are GMT +1. The time now is 11:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com