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

1 vote288 views1 answer
Add rows to datagridview vb.net
VBA
0 vote299 views1 answer
Vba test optional argument
VBA
0 vote318 views1 answer
Style percent not found vba
VBA
0 vote276 views1 answer
Vba loop through table
VBA
0 vote302 views1 answer
Build an index all files of a FTP site
VBA
0 vote286 views1 answer
Vbs expand env var
VBA
0 vote342 views1 answer
Visual basic cmd
VBA
1 vote271 views1 answer
Excel vba convert cells(1,1) into A1 and vice versa
VBA
0 vote310 views1 answer
Test if form is open vb
VBA
0 vote315 views1 answer
Supprimer la valeur de celule vba
VBA