Hi, Erin. Open your file. Hit Alt+F11 or Tools--Macro--Visual Basic
Editor.
Double-click ThisWorkbook. Paste the following code, hit the Save diskette,
and close and reopen your workbook to see it happen:

Option Explicit

Private Sub Workbook_Open()

MsgBox ("Starting June 2005 we will be receiving a print out list of ATS " &
vbCrLf & _
"(Application Toolig Solutions) invoices that paid sales tax." & vbCrLf & _
"This will be reported quarterly. This should be applied to the credit
sheet."), vbOKOnly

End Sub

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Erin" wrote in message
...
I am trying to display a dialog box that pops up when you first open an
excel
file. I want it to say...

Starting June 2005 we will be receiving a print out list of ATS
(Application
Toolig Solutions) invoices that paid sales tax. This will be reported
quarterly.
This should be applied to the credit sheet

I want it to have an "ok" button to close the dialog box.

How do I do this?