How do I find out which user has the workbook opened, by a dialog or mesage box, and then open the workbook and notify me when the workbook can be updated.
By Excel default, if someone else has the workbook open when you try to access it you should get a File Reservation message box with stating this workbook is being modified by "Someone" and you should have your choice to open as Read Only, Notify, or Cancel.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.