Disable Save Prompt in Excel

[LTDragon07]

is there a way to disable the save prompt when in an excel file?

I have a share macro excel sheet and I don't want it to ask to save the file.
When you manually close the file or Excel.
Is this possible?

 

[Domenic]

Set the Saved property of the Workbook object to True within the workbook's BeforeClose event handler (Alt+F11 > Ctrl+R > right-click ThisWorkbook > Copy/paste > Alt+Q)...

Option Explicit

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

Hope this helps!

 

[LTDragon07]

Thanks, that helped.
I did make a change to this code that suited my needs a bit more.

Private Sub Workbook_BeforeClose(Cancel As Boolean)

If ThisWorkbook.ReadOnly = True Then
ThisWorkbook.Saved = True
Else
End If

End Sub

 

[Domenic]

You're very welcome!