open the workbook
press "alt-f11"
double click "this workbook", it's a Microsoft Excel Object

Private Sub Workbook_Open()
msgbox("whatever text you want")
End Sub

press alt-f11 to get back to your sheet