I have an addin that operates the same aas the work menu in Word.
It allows me to open files quickly and easily without the bothersome network naviagtion.
It works fine, however it does not alert me to the fact that I am opening a readonly copy of the file before it opens. (the only way to tell is the read-only postscript added to the workbook name)
Is there a way I can :
1. Alert me when the file is opned that the file is being used by another, (so I can chose to open, notify later, cancel)and
2. Determine after opening it who is the other user (so I can track the user down to close the file so I can edit it)
Thanks in advance for any ideas