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" wrote in message
...
| 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