iabbott

Hi

I have a shared workbook, and I would like to know how to tell in code whether it is currently Shared or Exclusive (since certain things like deleting sheets can't be done while the workbook is shared)

I will use this to enable a button when the workbook is exclusive, and disable it when it is shared

I have tried the MultiUserEditing Property but this doesn't seem to work properly, the button is on a userform and is disabled by default, and code in Userform.Initialize will enable it when the workbook is not shared, but when I go into it in the shared workbook, the button is enabled as well...

The code I used is
Thanks

Kluz

I've never used the MultiUserEditing property before, does it refer to the potential of the workbook to be multi-used or if it's being multi-used at the present time?
Have you tried to have another person have the book open on another comp/user name when you test this code?

iabbott

OK I did a bit more playing around..

This does work as I expected (it will disable the button if the workbook is shared, regardless of if I'm the only one in it), but I had to close the workbook after changing from/to shared before it changed the status of the button

Very strange...

Kluz

Glad to see you've got it figured out.

iabbott

thanks for your help