Excel vba prevent saving workbook

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
    Cancel = True                       ' Cancels in any case
    ' Or :
    If SaveAsUI Then Cancel = True      ' Cancels only if saving is asked by user, not via code
End Sub

' Prevents Excel from requesting a save before closing
Private Sub Workbook_BeforeClose(Cancel As Boolean)
    Application.ThisWorkbook.Saved = True
End Sub

Similar codes

0 vote186 views2 answers
Get excel file from email attachment in vba
VBA
3 votes213 views1 answer
Excel vba get the workbook full filename with path
VBA
8 votes453 views1 answer
Excel vba make word from bytes
VBA
8 votes303 views1 answer
Excel vba determine number of elements in a 1D array
VBA
0 vote190 views1 answer
Excel vba first working day month
VBA
1 vote178 views1 answer
Textbox find and replace vb
VBA
4 votes136 views2 answers
Vba last row
VBA
2 votes138 views2 answers
Vba exit loop
VBA
0 vote187 views1 answer
Dynamic array vba
VBA
0 vote181 views1 answer
Do while not vb.net
VBA