Testing for Shared Workbook
 

I need to check to see if a workbook that resides on a networked drive has
been set to "shared" mode (Tools, Share Workbook...). Is that possible,
using VBA? If so, can someone please direct me to where I can find some
sample code? (I'm a VBA novice.) Thanks in advance for any help.
Bob

Testing for Shared Workbook
 

Maybe (is the workbook open?)...

MsgBox ThisWorkbook.MultiUserEditing



Bob wrote:

I need to check to see if a workbook that resides on a networked drive has
been set to "shared" mode (Tools, Share Workbook...). Is that possible,
using VBA? If so, can someone please direct me to where I can find some
sample code? (I'm a VBA novice.) Thanks in advance for any help.
Bob

--

Dave Peterson

Testing for Shared Workbook
 

Dave,
I looked up the MultiUserEditing property in Excel's help file. It appears
that it may do the trick. I'll have to test it out. Thanks for pointing me
in the right direction. I really appreciate it.
Bob


"Dave Peterson" wrote:

Maybe (is the workbook open?)...

MsgBox ThisWorkbook.MultiUserEditing



Bob wrote:

I need to check to see if a workbook that resides on a networked drive has
been set to "shared" mode (Tools, Share Workbook...). Is that possible,
using VBA? If so, can someone please direct me to where I can find some
sample code? (I'm a VBA novice.) Thanks in advance for any help.
Bob

--

Dave Peterson