Hi all,
I have the following code to open the file which has read-only option but my macro code will copy something from another file and paste in this file and save, so I need to choose a "No" to the read-only message when it tries to open the file. Currently, the message still pops up to me and I need to manually click "No"...
Workbooks.Open FileName:="Q:\Documents\Codes.xlsx", ReadOnly:=False
Thanks in advance for your help!
I have the following code to open the file which has read-only option but my macro code will copy something from another file and paste in this file and save, so I need to choose a "No" to the read-only message when it tries to open the file. Currently, the message still pops up to me and I need to manually click "No"...

Workbooks.Open FileName:="Q:\Documents\Codes.xlsx", ReadOnly:=False
Thanks in advance for your help!
