If you try to open a network file that was already opened
exclusively by another user, you get a yes/no/cancel
dialog that offers three choices as follows (I think):

1. Open the file read only;
2. Be notified when the file is available;
3. Cancel and forget it;

Is there a way to harness the capability of notifying a
user when the file is available? I want to invoke this in
a custom program that traps everything else.

The VBA code to do it is most appreciated. Thanks.