I have some VBA that transfers workbooks from the network to my local C drive, but some of them are locked by the user - usually for those the locked box tells me who the workbook is opened by, and asks me if I wanted to be notified, their 'lan_id' is displayed, is there any way to capture that ? before I close the workbook and go to the next ?
thanks!
thanks!