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

25 votes300 views3 answers
String to date vb
VBA
5 votes173 views1 answer
Excel vba second byte from INTEGER
VBA
3 votes158 views1 answer
Excel insert blank row for value change in column
VBA
0 vote153 views1 answer
Vba array of integers
VBA
0 vote146 views1 answer
Add Formula to Shape Text in VBA
VBA
0 vote153 views1 answer
Vbscript for loop
VBA
-1 vote158 views1 answer
Vba code to add new column in table
VBA
5 votes180 views1 answer
Excel vba how to unit test vba code
VBA
0 vote178 views1 answer
Vbnet check if string is only numbers
VBA
0 vote150 views1 answer
Excel vba join variant array
VBA