Breaking News: Grepper is joining You.com. Read the official announcement!

excel vba close without saving

VasteMonde answered on January 17, 2021 Popularity 8/10 Helpfulness 10/10

answer excel vba close without saving

related excel vba prevent saving workbook

excel vba close without saving

Comment

ActiveWorkbook.Close savechanges:=False

Popularity 8/10 Helpfulness 10/10 Language vb

Source: Grepper

Tags: excel vba

Link to this answer
Share Copy Link

Contributed on Feb 22 2021

VasteMonde

0 Answers Avg Quality 2/10

Closely Related Answers

excel vba prevent saving workbook

Comment

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

Popularity 7/10 Helpfulness 3/10 Language vb

Source: Grepper

Tags: vba excel

Link to this answer
Share Copy Link

Contributed on Jan 17 2021

VasteMonde

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

excel vba close without saving

Contents

More Related Answers

excel vba close without saving

Closely Related Answers

excel vba prevent saving workbook

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.