find out if a sheet is open by another user

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

Is there a way to find out in VBA if an xls is open in read/write mode by
someone and who that someone is.
Many thanks,
Dan
 
UserStatus does not work on a read only file - and I am interested to find
out who is the user that is locking the file, so that does not help me.

on the help file it is written:
"Remarks
The UserStatus property doesn't return information about users who have the
specified workbook open as read-only."

Thank you.
 
You must log in or register to reply here.

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

Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
Corrupted sheet - What the cause? 2
Open a specific sheet with VBA 2
Test to see if a workbook is open 2
Qery open and clos sheet 1
Vlookup from close sheet via VBA 4
sheet event wait for another event? 6
hard code a password in a vba code 2

Back
Top