Thread: Close & save a file at set time only IF the file is open
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Clivey_UK[_6_] Clivey_UK[_6_] is offline
external usenet poster
  
Posts: 1
Default 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 With QuoteReply With Quote