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

1 vote122 views1 answer
How to do error handling in access vba
VBA
0 vote134 views1 answer
Remove first character from string vb
VBA
0 vote151 views1 answer
Delete all controls in an area vb
VBA
0 vote129 views1 answer
Vba len variant
VBA
0 vote129 views1 answer
Type excel.application is not defined vb
VBA
0 vote139 views1 answer
Menus act like radio buttons vb.net
VBA
0 vote206 views1 answer
Find the name of the last excel sheet vb
VBA
5 votes170 views1 answer
Vba low word from Long Integer
VBA
0 vote146 views1 answer
VBA
VBA
0 vote143 views1 answer
.net crash app
VBA