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

Determine which user has write access to a file? 2
populate a combobox based on unique values in another workbook 16
Incorporating the User Profile location into a document template path 1
Language of the templates 0
Page numbering with Merged Document and IF statements 1
Checking if a workbook is open 7
Word VBA - Want to test if Full Name is NOT Present in document 0
Open Add-In (.xla) workbook as Read Only automatically 1

Top