This mod of Dave's code will also present the value in cell A1 in the Message
Box if you wish....

Option Explicit
Sub Auto_Open()
MsgBox "Your message here" & vbLf & Range("a1").Value
End Sub

Vaya con Dios,
Chuck, CABGx3




"Dave Peterson" wrote:

Option Explicit
Sub Auto_Open()
msgbox "Your message here" & vblf & "second line if you have one"
end sub

This goes into a general module.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

certain_death wrote:

Hi,
Can anyone help?
I would like a pop up message box upon opening a spreadsheet, that
would contain some of assumptions in the spreadsheet...
Please help if you can...
Nice one
Regards
Mark

--
certain_death
------------------------------------------------------------------------
certain_death's Profile: http://www.excelforum.com/member.php...o&userid=24561
View this thread: http://www.excelforum.com/showthread...hreadid=547494

--

Dave Peterson