[Fixed!] This Excel Workbook Was Opened in ReadOnly Mode
This Workbook Was Opened In Read-Only Mode. From the side of office, i would suggest you try the following steps. Document was reshared with me, nothing changed.
[Fixed!] This Excel Workbook Was Opened in ReadOnly Mode
On the file menu, click info. Next, open the security tab. Dim book as workbook set book = workbooks.open (filename:=filepath, readonly:=true) share follow edited. It is the most common cause of this error. Remove read only property if the file is already set as read only in its property it should be a read only file. Web 06/28/2022 8 contributors applies to: Web 10 possible solutions: Follow these steps to fix this error. For stronger protection, require a password to save changes. I never used to have this issue.
You may need to check with your antivirus provider to learn how to adjust these settings. Next, open the security tab. Besides, do you open the files from excel desktop application? Remove read only property if the file is already set as read only in its property it should be a read only file. Workbooks.open filename:=filepath, readonly:=true or, as pointed out in a comment, to keep a reference to the opened workbook: Web alex gordon 56.7k 287 670 1056 add a comment 2 answers sorted by: It is the most common cause of this error. For stronger protection, require a password to save changes. Web 10 possible solutions: Document was reshared with me, nothing changed. Make sure you have full control of this.
