Create a dialog box
 

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?

Create a dialog box
 

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?

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?

Create a dialog box
 

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

--

HTH

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


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