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