What is the syntax to run code after opening a workbook?

Insert this sub-procedure into the ThisWorkbook window under Microsoft Excel Objects folder:

Private Sub Workbook_Open()
   ‘your code here
End Sub
Advertisements