Determine if workbook is open

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!
 
R

Robert Crandal

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Determining whether a workbook is a 2003 or 2007 workbook 6
Excel 2013 menubar incompatibility? 1
Function or formula to show currently active workbook name in cell 1
How to determine which sheets appear on opening a workbook. 6
Test to see if a workbook is open 2
Open Add-In (.xla) workbook as Read Only automatically 1
Determine if a shared workbook is open 1
Test if a Workbook is Open 2

Top