Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Create Startup Dialog
Greetings, I have a worksheet that I wont to have a dialog box/window popup
when someone opens it giving them directions to operate my pivotreport. How can I do this? Can I have it so it pops up before anything else does? Thanks in advance. Cheers |
#2
|
|||
|
|||
You could use the workbook_open event and display a msgbox:
Sub Workbook_Open() Dim strLine1 As String Dim strLine2 As String Dim strLine3 As String Dim strLine4 As String 'Add more variables (lines) as needed Dim strLB As String Dim strNewRow As String strLB = Chr(10) strNewRow = Chr(10) & Chr(10) 'Define your message here strLine1 = "This is an example." strLine2 = "Please read this carefully." strLine3 = "Click on the first sheet." strLine4 = "Go to cell D3 and key in your name." MsgBox strLine1 & strNewRow & strLine2 & strNewRow & _ strLine3 & strLB & strLine4 End Sub --- To use, pres Alt+F11. Click on the ThisWorkbook Module of your current workbook and paste in the code. Press ALT+Q. Save. HTH Jason Atlanta, GA "coal_miner" wrote: Greetings, I have a worksheet that I wont to have a dialog box/window popup when someone opens it giving them directions to operate my pivotreport. How can I do this? Can I have it so it pops up before anything else does? Thanks in advance. Cheers |
#3
|
|||
|
|||
You could make a userform with your notes on it.
Debra Dalgleish has some notes for userforms at: http://www.contextures.com/xlUserForm01.html Then create a subroutine in a general module named auto_open Option Explicit Sub Auto_Open() userform1.show end sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Auto_Open will run each time that the workbook is opened (with macros enabled). coal_miner wrote: Greetings, I have a worksheet that I wont to have a dialog box/window popup when someone opens it giving them directions to operate my pivotreport. How can I do this? Can I have it so it pops up before anything else does? Thanks in advance. Cheers -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't create dynamic charts | Charts and Charting in Excel | |||
Template in Excel | New Users to Excel | |||
Excel's Dialog Box | Excel Discussion (Misc queries) | |||
Using the "Go To" dialog for "Copy" | Excel Discussion (Misc queries) | |||
trying to create | Excel Discussion (Misc queries) |