File is read only and cannot be overwritten


Some how execute macro making xlsm file to read only mode.

Did you already enable all option in the macro settings in the excel application scope.

And also please un check the save excel option if you are just reading the visible sheet names from xlsm file so un necessarily it will not try to save xlsm for each and every action.

Please try the above option and let us know. If you still not able to resolve the issue. If possible please share us the macro code you are trying run in that xlsm to help you better. Thanks.

1 Like