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 vote137 views1 answer
How to make a a msgbpx in vbs
VBA
0 vote151 views1 answer
Create new worksheet excel visual basic
VBA
0 vote133 views1 answer
Reset border color textbox vba
VBA
2 votes127 views1 answer
Vba file from path
VBA
5 votes143 views1 answer
Vba low byte from INTEGER
VBA
0 vote120 views1 answer
Vb streamreader
VBA
3 votes132 views1 answer
Vba http request json
VBA
0 vote130 views1 answer
Rotate image by any angle vb.net
VBA
0 vote130 views1 answer
Dynamically change drop down list visual basic
VBA
0 vote71 views1 answer
Excel autofilter vba
VBA