He said registry not directory. Every user has their own registry.

HTH

Bob

"Ryan H" wrote in message
...
Good point Dave. How do you check the users directory?
--
Cheers,
Ryan


"Dave Peterson" wrote:

Both Bob and Chip gave you code that creates a new name in the workbook.
But if
the workbook doesn't get saved, then the next time it's opened, the
msgbox will
appear again.

You could add this line to either procedure -- right above the "End Sub"
line:

ThisWorkbook.Save

ps. Remember that if 100's of people will be opening the workbook, then
this
technique will only show the msgbox to the first person who opens that
workbook
without the name.

After the name is created, then all the other users won't see the msgbox
even
once.

One way around this is to store a value in the user's registry and check
for
that using SaveSetting and GetSetting.



John wrote:

Hi Everyone
Is it possible to have a popup window ( Msgbox ) that will open only
one time.
The first time the workbook will be open, I would like to show the
message
"Please read the instruction first".
I don't want the message to keep opening every time the workbook is
open.
Regards
John

--

Dave Peterson
.