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 vote248 views1 answer
Excel vba unlock sheet without password
VBA
0 vote233 views1 answer
How to extract a file from an ISO:
VBA
5 votes250 views1 answer
Excel vba left word from Long Integer
VBA
-1 vote223 views1 answer
System.Data.OleDb.OleDbException: 'No value given for one or more required parameters.'
VBA
0 vote259 views1 answer
Create links in msgbox in vb
VBA
0 vote268 views1 answer
Vba registry settings
VBA
0 vote261 views1 answer
Vbnet round to nearnest thousand
VBA
-1 vote247 views1 answer
Vba code to add new column in table
VBA
31 votes302 views1 answer
Excel-vba how to convert a column number into an excel column
VBA
0 vote248 views1 answer
How to use if condition in time vba
VBA