turn off 'save' prompt when closing Excel

[Dawnyanne]

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

 

[Mike H]

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

 

[Dawnyanne]

Hi Mike

Thank you so much!!

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