I have an Excel 2000 workbook on a server.
As an idea I have:
If say person A opens this workbook I don?t
want anyone else to be able to open it (not even in Read Only mode)
until person A has closed the workbook on their pc.
I know about the ?File in Use? dialog,
which states the workbook is locked for editing,
which springs up if the workbook is already opened.
But this still allows the workbook to be opened (in Read Only mode).
Is it possible to bring up a user form,
(which will not allow the user to proceed to open the workbook, just a picture and an OK button)
instead of the ?File in Use? dialog?.
If so, how?s this possible?.
Thanks.