Checking if a workbook is shared

  • Thread starter Thread starter mika.
  • Start date Start date
....and that allows multiple users to work on it at the
same time?

Thanks.
 
Mika

Check out the MultiUserEditing and ExclusiveAccess properties of the
Workbook object in help.
 
Thank you..but I am still having trouble setting a
workbook to shared. If I understand correctly,
MultiUserEditing tells me whether it is shared or not and
EclusiveAccess sets it to not shared, but how do I set it
to shared?

Thank you kindly.
 
Mika

Sorry about that. I thought you could set MutliUserEditing, but you're
right, it's read only. You need to use the ProtectSharing method to share
it.
 
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

Shared Workbook Crash 0
Excel VBA 0
Visual Basic in a shared workbook 4
Testing for Shared Workbook 2
Disable share workbook option in VBA 2
Sharing workbooks limitations - Merged Cells 12
Check if Workbook is shared 2
shared file ! 2

Back
Top