excel vba prevent save

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

answer excel vba prevent save

related excel vba prevent saving workbook

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

Link to this answer
Share Copy Link

Contributed on Jan 15 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

excel vba prevent save

Contents

More Related Answers

excel vba prevent save

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.