excel vba prevent saving workbook

VasteMonde answered on January 15, 2021 Popularity 7/10 Helpfulness 3/10

answer excel vba prevent saving workbook

related excel vba close without saving

related excel vba prevent save

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: excel vba

Link to this answer
Share Copy Link

Contributed on Jan 17 2021

VasteMonde

0 Answers Avg Quality 2/10

Closely Related Answers

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

excel vba prevent save

Comment

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
    Cancel = True 
    msgbox "Forbidden."
End Sub

Popularity 3/10 Helpfulness 1/10 Language vb

Source: Grepper

Tags: save excel vba

Link to this answer
Share Copy Link

Contributed on Jan 15 2021

VasteMonde

0 Answers Avg Quality 2/10

excel vba prevent saving workbook

Contents

More Related Answers

excel vba prevent saving workbook

Closely Related Answers

excel vba close without saving

excel vba prevent save

Grepper

Documentation

Social

Legal

Contact

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