Hi Nick:

I'm afraid I don't know what the Excel sense is. (If you can help me with
that or point to information on the web, I'd be grateful.)

I was referring to a Workbook stored on a network server that is shared (ie
updated) by more than one person on the network. The Workbook only allows
one person at a time to make changes.

TIA
Geoff



"NickHK" wrote in message
...
Geoff,
Do you Shared in the Excel sense or shared as in more the one person uses
the WB ?
Understanding the difference may help you.
Make sure you understand the consequences of <Excel Sharing before you
apply it.

NickHK

"GeoffG" wrote in message
...
I've written VBA code to open a shared Workbook and make changes. I need
my
code to determine whether another user has the Workbook open and whether,
as
a consequence, my code is opening a read-only copy of the Workbook - in
which case, the code needs to abandon making changes, with advice to the
user to try again later.

Can I programmatically attempt to open a workbook in exclusive mode and
then
see if the Workbook opened? Or is there a property I can examine after
the
Workbook has opened to determine whether it's in read-only mode?

TIA
Geoff.