View Single Post
 
Old 11-06-2015, 03:43 AM
Debaser's Avatar
Debaser Debaser is offline Windows 7 64bit Office 2010 32bit
Competent Performer
 
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default

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.
Reply With Quote