Testing for Shared Workbook

[Guest]

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]

Maybe (is the workbook open?)...

MsgBox ThisWorkbook.MultiUserEditing

 

[Guest]

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