About Us

Ronnie[_3_]

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

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
macro to display message,when open workbook	puiuluipui	Excel Discussion (Misc queries)	7	October 13th 09 12:39 PM
if, then display message	puiuluipui	Excel Discussion (Misc queries)	1	October 2nd 09 05:28 AM
Display a message	Jarek Kujawa[_2_]	Excel Worksheet Functions	0	June 3rd 08 02:44 PM
Display message upon file open even with macro security set to high	[email protected]	Excel Discussion (Misc queries)	1	November 11th 06 02:43 PM
How to display a message box	Salman[_2_]	Excel Programming	1	November 5th 03 05:01 PM