VBA Detection of Workbook already Open

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top