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

4 votes242 views2 answers
Excel vba last column with data
VBA
0 vote236 views1 answer
Internet explorer reference vba
VBA
0 vote255 views1 answer
Visual stuiod not recognising desgined labels
VBA
0 vote274 views1 answer
Vba dictionary length
VBA
0 vote223 views1 answer
Le contrôle SpinButton (Toupie)
VBA
0 vote242 views1 answer
Vbnet check if sting contians symbols
VBA
2 votes242 views1 answer
Excel vba check if string entirely alpha
VBA
0 vote282 views1 answer
VBA Sort RossetaCode
VBA
0 vote228 views1 answer
Send webhook vbscript
VBA
0 vote273 views1 answer
Vba cell all borders
VBA