(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
 
 
 



Add comment

Security code
Refresh

Chillzee Tag Cloud

Let's Socialize

About Chillzee

Chillzee.com is an entrepreneurship portal.

The site provides informative topics on Organizational and Strategic needs.