Checking if a workbook is shared
 

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

Thanks.

and on similar lines...
 

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

Thanks.
-----Original Message-----
How would you set a workbook to shared using VBA?

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

Thanks.
.

.

and on similar lines...
 

Mika

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

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"mika." wrote in message
...
...and that allows multiple users to work on it at the
same time?

Thanks.
-----Original Message-----
How would you set a workbook to shared using VBA?

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

Thanks.
.

.

and on similar lines...
 

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.

-----Original Message-----
Mika

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

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"mika." wrote in message
...
...and that allows multiple users to work on it at the
same time?

Thanks.
-----Original Message-----
How would you set a workbook to shared using VBA?

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

Thanks.
.

.



.

and on similar lines...
 

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.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"mika." wrote in message
...
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.

-----Original Message-----
Mika

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

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"mika." wrote in message
...
...and that allows multiple users to work on it at the
same time?

Thanks.
-----Original Message-----
How would you set a workbook to shared using VBA?

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

Thanks.
.

.



.