Hi,
I have a workbook saved on a network used by multiple people. When one user has it open it comes up with the File In Use dialogue box saying who has it open, with the options Read Only, Notify & Cancel.
Is there a way that in this situation when the user clicks notify I can get Excel to update the user that has the active sheet open that someone is trying to use the sheet?

I have some basic VBA knowledge, but not advanced enough to figure this one out on my own!

Thanks for any help in advance.