View Single Post
  #3   Report Post  
 
Posts: n/a
Default

Thanks Julie,

Where do I go for this? (IE File, Edit, Etc) Am I somehow
making a macro run upon opening? I can't find my Que book
on Excel which would probably have this info in it. It's a
BIG book. (I think for something such as excel) Are there
links for this?

Thanks again.



-----Original Message-----
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?



.