You have to use the Workbook.SaveAs method and specify the AccessMode:=xlShared argument. You can check the MultiUserEditing property at the start - it will be True for a Shared workbook.
I also suggest you make a LOT of backups as your workbooks will go wrong eventually.
|