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 vote125 views1 answer
Excel vba unmerge sheet
VBA
0 vote135 views1 answer
Sort dictionary by key vba
VBA
0 vote147 views1 answer
How to enter Vbox manage commands
VBA
0 vote116 views1 answer
Docker vboxmanage not found
VBA
4 votes134 views1 answer
Excel vba Imitating the "IN" operator from python
VBA
0 vote127 views1 answer
Selecttoken em vbnet e json
VBA
1 vote134 views1 answer
Vb.net get name by Cell Click
VBA
1 vote124 views1 answer
Shortcut to apply a formula to an entire column in excel
VBA
0 vote145 views1 answer
Vba cell all borders
VBA
8 votes152 views1 answer
Excel vba make word
VBA