Share Excel 2007 Workbooks As. On the Review tab in the Changes group click Protect and Share Workbook. In Office Excel 2010 click on Options in the left pane.
The workbook will open in a new tab in your web browser. This also allows workbook. Enabling the Shared Workbook feature.
It used to be easy to remove the Shared status of the workbook through ReviewChangesShare Workbook.
Using a web browser upload or create a new workbook on OneDrive OneDrive for Business or a SharePoint Online library. VbPrivate Sub rxHost_Buttons Control As IRibbonControl Purpose. On the Review tab in the Changes group click Protect and Share Workbook. Just add the following after your last operation once your file is closed where of course resultFile is the workbook to be saved and resultFileName the path ApplicationDisplayAlerts False Set resultFile WorkbooksOpenresultFileName resultFileCheckCompatibility False resultFileSaveAs.