Checking if a workbook is shared

[mika.]

How would you check if a workbook is shared using VBA?

Thanks.

 

[mika.]

....and that allows multiple users to work on it at the
same time?

Thanks.

 

[Dick Kusleika]

Mika

Check out the MultiUserEditing and ExclusiveAccess properties of the
Workbook object in help.

 

[mika.]

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.

 

[Dick Kusleika]

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.