Advice please.

I have an application running on a network server that is accessible by a
number of different users.
I only ever want one person to use it at a time, and if another attempts to
open it I want VBA to deliver a message.

Presently the standard message created by Office, which tells the use
another user is modifying , do you want to open it read-only etc., is what
they see. Can I intercept this message and control whether they can open it
or not - even if read only ?

TIA

Cheers
Nigel




----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---