| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Close & save a file at set time only IF the file is open
Tom, Many thanks for that. Looks like just what I need. I should have thought of using BeforeClose. Clive Tom Ogilvy Wrote: You would need to cancel the scheduled event in the BeforeClose event. However, the user could possibly cancel when prompted to save and the workbook is never closed. -- Clivey_UK ------------------------------------------------------------------------ Clivey_UK's Profile: http://www.excelforum.com/member.php...o&userid=32569 View this thread: http://www.excelforum.com/showthread...hreadid=537788 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Open, Save and close Excel 2007 file with a cmd command | Excel Discussion (Misc queries) | |||
| Each time I close an Excel file, it asks if I want to save. | Excel Discussion (Misc queries) | |||
| Auto Open file VBA Refresh MS Query Save Close | Excel Programming | |||
| Open excel file, enter values, save & close | Excel Programming | |||
| Automate open file, update links, run macro, close and save file | Excel Programming | |||
![Clivey_UK[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
