Does anyone know if you can access the file reservation prompt box through VBA code?
I'm opening a file from a custom menu and in doing so not getting a message that the file is currently in use by "someone else". I need to figure out how to get the "File Reservation" message to trigger when opening through code?
Excel 97, Windows 98
Any ideas appreciated.