display message upon open

  • Thread starter Thread starter Ronnie
  • Start date Start date
R

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
 
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
 
Back
Top