Hi Phill

yes, you can get a message box (for a message) or an inputbox (if you want
to ask a question) or a customised userform to display when a workbook is
opened by putting worksheet_open code into the ThisWorkbook module of the
workbook. Note, however, they need to have their security settings set to
medium (or lower) and choose to "enable" macros (if it appears) when opening
the workbook.

sample Workbook_Open code would be as follows:
---
Private Sub Workbook_Open()
MsgBox "Hi " & InputBox("what is your name")
End Sub
---

if you'll like additional help please post back with more details

Cheers
JulieD


"Phill" wrote in message
...
Is it possble to make a dialog box pop-up when someone
opens a spreadsheet?