View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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