Shared Workbook flag?

How can I see if a workbook is Shared?
Is there a flag i can look at?

thanks for your help
jahrens

I don't know what kind of flag you mean but I don't think MS has documented
a way to detect whether a file is shared, short of opening it. Of course
there has to be something in the file that indicates this but you probably
don't want to guess.

--
Jim
"Jörgen Ahrens" <jahrens@community.nospam> wrote in message
news:eeyXc4FOGHA.1760@TK2MSFTNGP10.phx.gbl...
| How can I see if a workbook is Shared?
| Is there a flag i can look at?
|
| thanks for your help
| jahrens
|
|

Visually, you can see [Shared] in the title bar.

In code, you could check .MultiUserEditing in VBA's help.

"Jörgen Ahrens" wrote:
>
> How can I see if a workbook is Shared?
> Is there a flag i can look at?
>
> thanks for your help
> jahrens

--

Dave Peterson