Test if File is Shared using VB

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PCLIVE - 17 Apr 2008 14:56 GMT

Using VB, I'm trying to test if the activeworkbook is shared.
Something like this, but it doesn't work.

If ActiveWorkbook.ExclusiveAccess = False

So how would I write this code?
Thanks,
Paul

--

Reply to this Message

PCLIVE - 17 Apr 2008 15:02 GMT

Nevermind, I think I got it.

If ActiveWorkbook.MultiUserEditing = True _

Thanks anyway.
Paul

> Using VB, I'm trying to test if the activeworkbook is shared.
> Something like this, but it doesn't work.
[quoted text clipped - 4 lines]
> Thanks,
> Paul

Reply to this Message