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 vote198 views1 answer
Label de tableau dans des label.text en VBA
VBA
0 vote192 views1 answer
Return na vba
VBA
0 vote204 views2 answers
How to update date and time automatically once id is entered in excel vba
VBA
0 vote207 views1 answer
Vba get workbook name
VBA
6 votes201 views1 answer
Excel vba isalpha
VBA
4 votes184 views1 answer
Excel formula for last non-empty cell in a column
VBA
1 vote203 views2 answers
Vba function return array
VBA
0 vote203 views1 answer
Openfiledialog specific folder
VBA
1 vote205 views1 answer
Vba date to unix timestamp
VBA
0 vote207 views1 answer
Vb run command
VBA