I am trying to achieve the following using VB6. Open an existing excel file at button click event and disable the File->Open->Browse option. To prevent users from opening any other file from the File explorer.

Currently, the user is not able to open another file after the file is selected from the Browse file explorer. Now I need that the file explorer to not open at all when File->Open is selected. I have tried different options like, trying to disable the Ribbon entirely(which is not ideal), and disable using the commandbars option, which doesnot work. I am trying to find an event that is triggered when the File->Open is selected. The event WorkBook_Open() is triggered after the file is selected from the Browse File explorer.