(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

Author: Oxygen
Other articles by this author

Chillzee Tag Cloud

Let's Socialize

About Chillzee

Chillzee.com is an entrepreneurship portal.

The site provides informative topics on Organizational and Strategic needs.