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 vote356 views1 answer
Excel vba calculate
VBA
0 vote367 views1 answer
Columns dont autoresize on program start vb.net
VBA
0 vote377 views1 answer
Vbnet access System.InvalidOperationException: 'Update requires a valid UpdateCommand when passed DataRow collection with modified rows.'
VBA
0 vote353 views1 answer
Vbnet get file name from path
VBA
0 vote402 views1 answer
Supprimer la valeur de celule vba
VBA
0 vote329 views1 answer
Excel vba assign shortcut key to button
VBA
0 vote369 views1 answer
Vba integer to double
VBA
0 vote368 views1 answer
How to enter Vbox manage commands
VBA
8 votes392 views1 answer
Excel vba determine number of elements in a 1D array
VBA
1 vote358 views1 answer
Excel vba force recalculation
VBA