How to remove read only permission for Excel file?

Question

Referring to following online file, I would like to know on how to remove read only permission for Excel file using macro.

Does anyone have any suggestions?

Thanks in advance for any suggestions

https://1drv.ms/x/s!AuvJV0hx3xTGiBuDM2L8N65oY6Yx?e=H0mqr6

Answer 1

Not sure what you want to do but if you want to change permissions on files on your local drive using macro then see https://www.techonthenet.com/excel/formulas/setattr.php

Answer 2

I try following coding to set into normal, but when I open this file, it still pop up read only message.

Do you have any suggestions on how to remove read only attribute using macro?

Thank you very much for any suggestions (^v^)

Sub Normal()

SetAttr "C:\Test.xls", vbNormal

End Sub

Answer 3

I tested the code and it worked for me.

Please describe the steps you are taking to reset the attribute.

I created Test.xlsx in C:, set it to Read Only in File Explorer, added your code (just changed .xls to .xlsx) to a new Excel file and ran the code... it removed the Read Only setting...

BEFORE Running the Code

AFTER Running the Code

Answer 4

There is some special attribute for read only, please download my linked file again, under property, read only is unchecked, but when I open this file, it pops up a read only message.

Do you have any suggestions on what attribute is about?

Thank you very much for any suggestions (^v^)

Answer 5

Can you share a screenshot? Looks like you are getting a security warning one gets while opening files downloaded from internet.