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 vote102 views1 answer
Vbide vbproject reference
VBA
0 vote143 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
3 votes162 views1 answer
Excel vba get the workbook full filename with path
VBA
0 vote151 views1 answer
Vba boolean to string
VBA
18 votes286 views3 answers
Excel-vba make integer
VBA
0 vote147 views1 answer
Vbnet hex to binary
VBA
0 vote158 views1 answer
Date as number vb
VBA
0 vote148 views1 answer
Group controls programmatically vb
VBA
0 vote161 views1 answer
Visual stuiod not recognising desgined labels
VBA
1 vote144 views1 answer
Change the first item in a queue vb.net
VBA