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.
.

.



.