View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Raza
 
Posts: n/a
Default Create a dialog box

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" wrote:


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)


"Raza" wrote in message
...
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?