turn off 'save' prompt when closing Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi there
Is there a way to 'turn off' the prompt "Do you want to save your changes?"
when you close excel? Many thanks for any help!

Dawnyanne
 
Hi,

Alt+F11 to open VB editor. Double click this workook and paste this in:-


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


Mike
 
Hi Mike

Thank you so much!!

Mike H said:
Hi,

Alt+F11 to open VB editor. Double click this workook and paste this in:-


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


Mike
Click to expand...
 
Back
Top