VBA Detection of Workbook already Open

  • Thread starter Thread starter Nigel
  • Start date Start date
N

Nigel

I have a workbook that runs on a network and wish to
intercept if any user has the file open. At the moment
the standard Excel message appears with the option to open
it read only etc.

My intention is prevent users from doing anything if the
workbook is already open, display a message to this effect
and then close the file.

TIA
Nigel
 
Back
Top