I want "locked for editing" message

[Dan Williams]

I like the message that says

Wbook.xls is locked for editing
by 'Username'
Click 'Notify' to open a read-only copy of the document and
receive notification when the document is no longer in use.

But if I open a workbook via

Workbooks.Open Filename:="Wbook.xls"

...it just opens Read-only, which is not what I want.

Can I get VBA to do this, so the user would be notified? I could
duplicate the text in VBA, but it wouldn't notify anybody.

Dan Williams
danwPlanet

 

[Dan Williams]

Thanks!

(I had deleted my posting when I realized I should have gone back to
Help and looked at Workbooks.Open. Then I saw your reply, which in
Google Groups now appears as a reply by itself. I replied with a
thank-you, but now when I look in Google Groups, my thank-you didn't
take, so here's another try. Thanks again!)
Dan

 

[Guest]

No problem. Thx for the reply.