Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 11-06-2015, 03:43 AM
Debaser's Avatar
Debaser Debaser is offline Un-share and re-share a workbook? Windows 7 64bit Un-share and re-share a workbook? 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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Un-share and re-share a workbook? How to share cell data between tabs of workbook? littlekeith Excel 1 03-23-2015 06:21 AM
share contactlist Flip Outlook 0 04-07-2014 06:39 AM
Can not share Calendar debbiewake Outlook 0 09-19-2012 07:02 AM
Share Archiwum, w1ckd Outlook 3 06-28-2011 01:10 AM
Share Workbook cannot merge Ichigo Excel 3 01-19-2010 03:05 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:06 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft