Detecting open workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My application is stored on a server that can be accessed by a number of users.

When the workbook is already in open by a user and another person opens it,
they get the warning to either not open, be notified or open as read only.

How can I detect this and force the workbook to open as read only in VBA code?

I need to detect it as I want to control the workbook save/close events and
ignore any changes.

Cheers
 
I am not sure you can detect that, but in the events you can do

if thisworkbook.ReadOnly then exit sub
 
Hi Tom
That is a pity. What you are saying is that after the user chooses READ
ONLY, only then can I detect a read open status.

Is there another way of testing if a server file is already open? I could
then create a local application that runs a test before it goes off and opens
the remote file. Or do I run into the same issue again?

Cheers
Nigel
 
Back
Top