display message upon open

[Ronnie]

I would greatly appreciate if someone would help me with
the following:
I would like to display a message when a particular excel
file is opened.

Thank you in advance.
Ronnie

 

[Gord Dibben]

Ronnie

Right-click on the Excel button to the left of the File button on Menu

Select "View Code"

Paste this code in

Private Sub Workbook_Open()
MsgBox "Greetings from Ronnie"
End Sub

Save/close and re-open to see your message.

Gord Dibben XL2002