Excel vba prevent save

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
    Cancel = True 
    msgbox "Forbidden."
End Sub

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 vote359 views1 answer
Search combobox items vb.net
VBA
-1 vote339 views1 answer
Text to speech vb.net
VBA
0 vote360 views1 answer
Vbs exec hidden
VBA
0 vote375 views1 answer
Vba clear collection
VBA
0 vote387 views1 answer
Vba count all row
VBA
0 vote355 views1 answer
Search for text in every worksheet excel visual basic
VBA
1 vote345 views1 answer
Excel date to unix timestamp
VBA
0 vote384 views1 answer
Sort dictionary by key vba
VBA
18 votes512 views3 answers
Excel-vba make integer
VBA
0 vote341 views1 answer
Vb check if row has column
VBA