Excel vba close without saving

ActiveWorkbook.Close savechanges:=False

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 vote291 views1 answer
Vba get workbook name
VBA
0 vote337 views1 answer
How to call gcd in vba
VBA
0 vote279 views1 answer
Reset border color textbox vba
VBA
0 vote277 views1 answer
Excel vba scroll to cell
VBA
0 vote292 views1 answer
VBA is form loaded
VBA
0 vote291 views1 answer
How to add line graph vb net
VBA
0 vote292 views1 answer
Selecttoken em vbnet e json
VBA
0 vote294 views1 answer
Send webhook vbscript
VBA
1 vote284 views1 answer
Excel vba force recalculation
VBA
0 vote262 views1 answer
Add Formula to Shape Text in VBA
VBA