Thread: Close workbook without saving file
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] joshuafandango@dsl.pipex.com is offline
external usenet poster
  
Posts: 21
Default Close workbook without saving file
Hi Kent,

In the 'This Workbook' object:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Me.Saved = True
End Sub

Cheers,
JF.
Reply With QuoteReply With Quote