(Reading time: 1 minute)

Excel

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

 

Example

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

Oxygen
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.