It looks like you didn't get all the code, there, Erin.
Here's a file with it in it:
http://www.myexpertsonline.com/freedls/msgboxonopen.xls
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Erin" wrote in message
...
it says complie error / snytax error now what. it has the Private Sub
Workbook_Open() highlighted in yellow and has MsgBox ("Starting June 2005
we
will be receiving a print out list of ATS " &
vbCrLf & _ just highlighted.

"Anne Troy" wrote:

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?