View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Scott buckwalter Scott buckwalter is offline
external usenet poster
 
Posts: 7
Default Disable Save Workbook popup

Found it.

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

Works.

"Scott buckwalter" wrote:

I have a workbook that I do not want the user prompted to save whenever they
close it. Is there a way I can disable that popup? Maybe override the
Workbook_OnClose event?