After selecting a folder, you will get the Save As dialog box as the picture below. You might need to save it as another file name if you have already named the document. Similar options are available for other common office software, including Microsoft Word. . Enter a password to make Read-only Passwords are not 100% secure Passwords entered using this method are not encrypted and can be cracked.
Click Ok for changes to take effect and click ok final ok to exit from Properties window. However, it would still be possible to use the keyboard to navigate around and edit the cells under the shapes. So, these are the ways to make an Excel file read-only and disable read-only from a read-only Excel file. It says: the file is reserved by someone. It is a piece of cake! My primary objection to the password approach is that I have to remember that it's blank.
General Options dialog box will appear as the picture below. As we can see, marked as final can prevent other users from deliberately deleting, changing, moving data on this Excel file, but it make sense to avoid accidental modifications or erasures in the Excel file. Now in this article, I will list several possible cases that make your workbook and worksheet read only and introduce how we can do to remove read only status from Excel file. What I have found is when I've protected it, the user is given an option to open as a read only or not! UserName What if you need a secure read-only option? Malicious users can edit the file and remove the password. Open this Excel file, you will find the read only is disable.
This is using Excel Version 1808 Build 10730. In the image above, select a Folder where you want to save your Excel file. This article has also been viewed 69,275 times. From the drop-down box, click General Options… 5. This is a problem if you want nobody can edit your file. When you try to edit these specific cells inside the range, you will get a prompt box as below screenshot shown. Please, I beg you, test and confirm steps before posting solutions.
Once you add it, you can edit the icon and name. Step 2: Select the Review tab and click Protect Sheet. Why was doing this so incredibly easy in 2003 and so seemingly impossible, now, in the 2010 version? And you have to enter the password if you want to edit the file. If want to disable read only in Excel, enter password for write access. The Immediate window will open below the code window.
Type the following into the Immediate Window and press enter see example in the screenshot above. When the Excel file is opened as read only, and was made changed, it won't be able to save to the same file name on the same location, but it is able to be saved to another name and another location. If you want to open the file as read-only, you will press the Yes option. Open the password protected read-only file Now our file is made read-only using a password. Select For Each CurCell In Selection If lastCellFx. When clicking on cell A3, A4 or A5 in current worksheet, you will get a Kutools for Excel dialog box as below screenshot shown, and the cursor will move to the right adjacent cell automatically. Now choose a destination for the file and name it.
Can I do it with Microsoft? From the General Options dialog box, click to place a checkmark beside Read-only recommended. Sometimes, like when opening an email attachment, it will open in Protected View by default, but not when opened from the server. Keep in mind that people may be able to copy data from the spreadsheet to another spreadsheet or file, and then edit it there if they wish to do so. I input a password in the Password to modify field. Share in the comment box.
Step 5: Finally, press Ctrl + S to save the spreadsheet. Say I have an Excel file. Making your document a read-only file means that the document can be read or copied but not modified. He was awarded the Knight Foundation scholarship to Northwestern University's Medill School of Journalism. He said that you could add code to a personal macro wb that would do this.
My comment is that it does essentially do so but there is one thing I do not like. Now, with the new user highlighted, select the type of access you wish to allow. To keep changes, they have to save this workbook with a new name or in a different location. Any way the read-only versions can be updated automatically or the users can be advised the changes have been made and to refresh? I am having to save it on my hard drive and upload everytime which gets confusing for all the other users on the company website. Update This seems to have resolved our issue. That means the user will be able to edit or update the file. Now click on Owner tab in Advance Security Settings for User windows 6.