| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
Thanks Anne!
"Anne Troy" wrote: 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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I make Excel display a message (dialog box) upon opening a spreadsheet? | Excel Discussion (Misc queries) | |||
| Excel's Dialog Box | Excel Discussion (Misc queries) | |||
| Display a dialog box if cell is empty | Excel Discussion (Misc queries) | |||
| Conditional display of a .jpeg file? | Excel Discussion (Misc queries) | |||
| Combine & Display “Fixed” & “Automatically Updated” Date Parts | Excel Worksheet Functions | |||
Threaded Mode
