I have the macro set up to limit the access via a password, but don't know where or how to set up these other changes. I just know that I am not the only being on the planet who wants to do this. Case 4: Worksheet and Workbook structure is locked and read only While your excel file is read only and you know it is because worksheet and workbook structure is protected, it will be easy or difficult to disable read only. Hope that makes sense and someone can help. So, if you don't want to make change to this Excel file, click on Yes to open it. Jan 4, 2007 I'm trying to open a file on a network drive. All of a sudden today, when I open the spreadsheet and enter the correct password, it still opens but only as Read Only.
Is there a way of identifying the password?? Why does Microsoft shoot itself in the foot, and us in the back, like this? I'm not reimbursed by TechRepublic for my time or expertise when helping readers, nor do I ask for a fee from readers I help. Balancing the two needs can be a bit of a high-wire act. I uncheck the read-only attribute. Microsoft Weekly Newsletter Be your company's Microsoft insider with the help of these Windows and Office tutorials and our experts' analyses of Microsoft's enterprise products. The setting you want is in Excel, not in SharePoint. What do I need to add to this code to automatically input this password? If that is true, then I would take a look at the security options within Excel.
Feedback Buttons provided by - Copyright © 2019 DragonByte Technologies Ltd. Whether you want other people to edit your excel workbook without permission? Reopen the spreadsheet, and now you will have the coveted read only function and a password to edit. How to remove read only from excel file when it is marked as final? Excel's password protection is a great feature and fortunately, it's easy to implement. Apr 9, 2008 Is there a way to remove the option to open a file as read only when the file is already open by another user? It would be easy enough to use but you'd have to put a button on your toolbar somewhere to call that macro. However I only want it to be edited by those who have the password to prevent any accidents. This file is dated back in 2004. Apparently things have changed a bit in Excel 2010 and I cannot seem to replicate the same security level as with the prior versions explained above.
Way 5: Protect sheets in Workbook to keep read only 1. Hi Wondering if anyone can help. I'm curious why you don't like it. I still get the password box pop up but it is smaller and does not contain the read only button. Step 1: Double click on the Excel file to open it. I checked the property of the file.
If don't need the read-only recommended on this Excel any more, how to remove it? It doesn't appear to be locked. . Just remember that this password only keeps users out; a user that knows this password has access to all the data and can modify the data once in. Please mention the app and version that you're using. This user just can't save the changes to the protected workbook. How do I remove the local Read-only attribute in Excel? When contacting me, be as specific as possible.
Remember to change the password in the code. When saving, Excel whines that it's read only. In prior versions of excel, you can protect a workbook and users when opening the file would be asked to enter the password to open with full editing priveleges or allow the user the option to open as read only. It seems you cannot do any changes on it, but you can save the read-only excel file as another one to remove modify password. But I think some options you have used to set excel workbook read only, would be able to remove this setting always. Tips: There is another way you could also protect workbook from editing. Make it impossible to edit the sheet until you click a specific button You've already stated that protecting the sheet with a blank password is not the approach you want but it's certainly the simplest.
I came close to it but then workbook structure like copying a worksheet within the workbook would be disabled. By this way you can make an workbook in excel 2010 read only and prevent users from making any changes to the file. I want to make one of the worksheets in an Excel 2010 workbook read-only, but I don't want to use a password. A Tools dropdown appears near the Save As button. Editor's note: In the video, Brandon Vigliarolo walks you through the steps of securing an workbook with a password in. This for me leaves it open to forgetting to reprotect when finished with it.
As if it just ran as Read Only all the time then it wouldnt matter what other users were editing at any given time. Then a message would prompt you that the settings would turn off typing, editing commands and proofing marks. Otherwise, you just could open the workbook read only. Here's the deal: A user without the modifying password can still view, modify, and save changes, if the user can get in. From then on, the copied Excel file would be not read-only and could be used instead of original one. Click Save button in Save As dialog to save workbook and replace the original one.