(Reading time: 1 minute)


BeforeSave event is very useful for running customized code while saving the workbook.



Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel as Boolean)
    a = MsgBox "Ok I am saving the sheet now.............."
End Sub

Add comment

Security code

Chillzee Tag Cloud

Let's Socialize

About Chillzee

Chillzee.com is an entrepreneurship portal.

The site provides informative topics on Organizational and Strategic needs.