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 vote297 views1 answer
Vbnet display all axis labels in cahrt
VBA
0 vote308 views1 answer
Excel vba disable keyboard input
VBA
0 vote305 views1 answer
Vba len variant
VBA
0 vote293 views1 answer
Vbnet dynamically change excel sheet name
VBA
0 vote316 views1 answer
For each item in folder outlook vba
VBA
5 votes880 views1 answer
Vlookup vba
VBA
0 vote325 views1 answer
Vba run command
VBA
0 vote331 views3 answers
Write to text file vb.net
VBA
0 vote445 views1 answer
Vba array of integers
VBA
0 vote296 views1 answer
Vba loop through table
VBA