Does Excel 2007 have any functions or means of determining
if a workbook is currently opened or being used by another user??

For example, if a workbook file is already open and a user
named Joe Smith has it open, I would like to display a message
box message like "User joesmith is currently using workbook!".

Thank you!

Perhaps:

http://www.vbaexpress.com/kb/getarticle.php?kb_id=468
--
Gary''s Student - gsnu201001


"Robert Crandal" wrote:

> Does Excel 2007 have any functions or means of determining
> if a workbook is currently opened or being used by another user??
>
> For example, if a workbook file is already open and a user
> named Joe Smith has it open, I would like to display a message
> box message like "User joesmith is currently using workbook!".
>
> Thank you!
>
>
> .
>

Thank you Gary's Student! This should solve at least half of my
problem....I'll test that for Excel2007. thank u


"Gary''s Student" <(E-Mail Removed)> wrote in message
news:24F31C31-5676-45C7-8344-(E-Mail Removed)...
> Perhaps:
>
> http://www.vbaexpress.com/kb/getarticle.php?kb_id=468
> --
> Gary''s Student - gsnu201001
>
>