|
How do I display a dialog box that pops up when you first open exc
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? |
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? |
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? |
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? |
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? |
| All times are GMT +1. The time now is 05:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com