ExcelBanter - turn off 'save' prompt when closing Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - turn off 'save' prompt when closing Excel (https://www.excelbanter.com/excel-worksheet-functions/158682-turn-off-save-prompt-when-closing-excel.html)

Dawnyanne

turn off 'save' prompt when closing Excel

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

turn off 'save' prompt when closing Excel

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" wrote:

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

Dawnyanne

turn off 'save' prompt when closing Excel

Hi Mike

Thank you so much!!

"Mike H" wrote:

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" wrote:

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

All times are GMT +1. The time now is 07:36 PM.