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]