Determine if workbook is open

  • Thread starter Thread starter Robert Crandal
  • Start date Start date
R

Robert Crandal

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
 
Back
Top