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 vote142 views1 answer
Vba boolean to string
VBA
0 vote144 views1 answer
Vbs write file
VBA
0 vote145 views1 answer
Excel vba delete folder
VBA
1 vote146 views1 answer
Vbs run
VBA
0 vote155 views1 answer
Add text to Shape VBA
VBA
0 vote151 views2 answers
Vba remove line breaks
VBA
0 vote164 views1 answer
Vba random number
VBA
0 vote137 views1 answer
System.InvalidOperationException: 'Row associated with the currency manager's position cannot be made invisible.
VBA
1 vote144 views1 answer
How to put a gridpain in a vbox
VBA
0 vote151 views1 answer
Vb run command
VBA