display message upon open
 

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

display message upon open
 

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

On Sat, 22 Nov 2003 10:40:57 -0800, "Ronnie" wrote:

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