Hi Kanye
You can put code against the Workbook_Open procedure in the ThisWorkbook
module ...
open your workbook, press ALT & F11 to get to the VBE window
in the project explorer (view / project explorer) under your file (the name
will be bold & in brackets), you'll see all your sheets listed and then
something called ThisWorkbook
double click on it,
from the left hand side drop down box on the right hand side of the screen,
choose workbook and the
Private Sub Workbook_Open()
End Sub
will be created for you - put your code in here.
However, for the code to run - tools / macro / security needs to be set to
medium (or low, but don't recommend this) and if you're asked you need to
enable macros on opening the file.
--
Cheers
JulieD
check out
www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"kanye" wrote in message
...
How do I create an automatic message that will be displayed everytime a
particular file is opened?