Create a dialog box

[Guest]

I have a few tricky workbooks made up for my staff.

The most elegant solution would be to have a dialog box open up everytime
the workbook opens. The dialog box would give a few pointers to how to use
the workbook and then they would click OK before using it.

Is this possible or a pipe dream?

 

[Bob Phillips]

Private Sub Workbook_Open()

Msgbox "your message here"
End Sub

'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code



--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Bob-

Thanks for you help! One last question: How do I make 2 lines of text
instead of 1 long line of text?

Thanks!

-Raza

 

[Bob Phillips]

Msgbox "This is the first line " & vbNewLine & _
"and this is the second"

--

HTH

RP
(remove nothere from the email address if mailing direct)