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 vote209 views1 answer
Vb streamreader
VBA
0 vote226 views1 answer
Vbnet chart make 0 gridline line different color
VBA
0 vote218 views1 answer
How to get value from clipboard in vbnet
VBA
0 vote208 views1 answer
Vba add spaces
VBA
0 vote205 views1 answer
Vba parameter adodb null value
VBA
0 vote215 views1 answer
Vba collection key list
VBA
0 vote214 views1 answer
Make all controls in an area not visable vb
VBA
0 vote219 views1 answer
Supprimer la valeur de celule vba
VBA
0 vote229 views1 answer
Vba multiple optional arguments
VBA
-1 vote201 views1 answer
For i in range vba
VBA