Microsoft Office Forums - View Single Post - Message to Protect Sheet after a command

Thread: Message to Protect Sheet after a command

View Single Post

Old

09-30-2021, 08:37 AM

Logit

Logit is offline

Logit uses Windows 10

Windows 10 Logit uses Office 2007

Logit uses Office 2007

Office 2007

Expert

Join Date: Jan 2017

Posts: 533

Logit is a jewel in the rough

Logit is a jewel in the rough

Logit is a jewel in the rough

Default

This macro, placed in the ThisWorkbook module, will save the workbook without notifying the user :

Code:

Option Explicit

Private Sub Workbook_BeforeClose(Cancel As Boolean)

    Application.DisplayAlerts = False
    ThisWorkbook.Save
   
    Application.DisplayAlerts = True
    Application.Quit

End Sub

Reply With Quote