Automatic message
 

How do I create an automatic message that will be displayed everytime a
particular file is opened?

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?