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 vote209 views1 answer
Excel vba first and last row and column in range
VBA
0 vote205 views1 answer
Not allow form to be resized
VBA
0 vote213 views1 answer
Vba sort the data Z to A
VBA
0 vote197 views1 answer
Vbnet display all axis labels in cahrt
VBA
0 vote230 views1 answer
Vba round to 2 decimals
VBA
0 vote245 views1 answer
Set datetimepicker value to null vb
VBA
0 vote199 views2 answers
Excel vba copy paste after last row
VBA
2 votes270 views1 answer
Vba round number
VBA
0 vote220 views4 answers
Vgrive,deb
VBA
0 vote274 views1 answer
Vba is integer
VBA