I am trying to use VBA code to select "Read-Write" upon notification that the file is now ready for editing. Please note that I do not want to use SendKeys as users may be working in other files when the file becomes open for editing.

So when a user is in the file and I go to open it I get the following dialog boxes:

Here is the first one:
Picture1.png

The second one:
Picture2.png

When the user exits the file I get the following:
Picture3.png

My existing code gets me to the last window. I recorded a macro to see what happens when I click "Read-Write" for the third window but it only outputs the following:

ActiveWorkbook.ChangeFileAccess Mode:=xlReadWrite, Notify:=True

This only brings up the check to see when the file is open for editing but does not effectively click the "Read-Write" option.

I have tried googling the problem but have not found an answer yet. Any help that can be provided would be appreciated. Thanks.