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" wrote in message
...
Perhaps:

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