Hi
yes, basically you're making a macro to run when the workbook opens ... to
get to the ThisWorkbook module, right mouse click on one of the sheet tabs
in the workbook and choose view code - down the left hand side of the VBE
Window you should see the Project Explorer .... and your filename should be
listed in bold and brackets - if you can't see the project explorer window
choose view / project explorer
then amongs the objects under your workbook's name you'll see ThisWorkbook -
double click on it and then on the right hand side of the screen choose
Workbook from the left most drop down box and you'll get a workbook_open
procedure created for you with
sub workbook_open()
end sub
the code needs to go in here.
i'm not sure what references to give you - Chip Pearson has a good article
on events
http://www.cpearson.com/excel/events.htm and a general basic
reference (but doesn't mention workbook_open macros)
http://web.archive.org/web/200312040...01/default.asp
but if you'ld like to post back with what you want to happen when the
workbook opens we can help you with the code.
Cheers
JulieD
wrote in message
...
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?
.