Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detect If Excel WB Is Shared?
Hi MDW,
MDW wrote: However, my code seems to fail if the workbook is shared for multiple users. I've been looking around the help and I can't find any way to detect this. Does anyone know a way to a) detect if a workbook is shared and b) remove the sharing if needed? Sebastien is correct - you can use the MultiUserEditing property to see if a workbook is shared. If you want to remove sharing, you can use the ExclusiveAccess method: ActiveWorkbook.ExclusiveAccess -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Detect open-state of xls from outside Excel | Excel Discussion (Misc queries) | |||
How can I detect that an excel cell has been clicked | Excel Discussion (Misc queries) | |||
Detect what version (if any) of Excel is installed | Excel Programming | |||
detect the Excel Update exc0901 | Excel Programming | |||
Detect Excel Version | Excel Programming |