Home Office Tips Excel VBA Start automatically a code if you open or close an Excel sheet
Start automatically a code if you open or close an Excel sheet PDF Print E-mail

This example shows the code to start a code automatically if you open or close the Excel sheet.

 

 

Code:

 

Private Sub Workbook_BeforeClose(Cancel As Boolean)
   MsgBox ("Good By World!")
End Sub

Private Sub Workbook_Open()
   MsgBox ("Hello World!")
End Sub

 

 


Automatisches_Ausfuehren_beim_Oeffnen_und_beim_Schliessen-VBA.zip