csehz
asked on
VBA Excel 2000 - Remove Sharing
Dear Experts,
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
ActiveWorkbook.ExclusiveAc cess
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?
thanks,
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
ActiveWorkbook.ExclusiveAc
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?
thanks,
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER