How do I display a dialog box that pops up when you first open exc

G

Guest

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?
 
A

Anne Troy

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
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to add a dialog box when you first open excel workbook 1
how do I clear a dialog box in Excel that is not a comment? 1
How do I turn off "Initializing Folders" every time I open a file. 1
Help, how do you open dialog box to filter a column 4
A dialog box pops up when I start my application 4
I want a dialog box when opened 1
How do I change the file open dialog box? 3
Open Existing Database dialog box at startup 3

Top