Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display "macro-free workbooks - VB project message" on closing Exc | Excel Discussion (Misc queries) | |||
Closing workbooks w/o closing Excel | Excel Discussion (Misc queries) | |||
close workbooks without closing excel ? | Excel Discussion (Misc queries) | |||
closing multi workbooks | Excel Discussion (Misc queries) | |||
Stop the prompt to save when closing workbooks | Excel Discussion (Misc queries) |