VBA Excel 2000 - Remove Sharing
Posted on 2011-03-25
I would like to remove share by VBA code, so the same which would be done through menu Tools/Share Workbook and removing the flag in section "All changes by more than one user..."
The macro record would do this with a single line
but the problem it brings error message if the file is not shared originally.
Could you please advise how a check could be before this line whether the workbook is shared or not?