But if you want to disable excel file read only, removing or recovering excel file password to is necessary at first. Getting Excel to prompt with a read-only recommended message or password field is a straightforward process requiring little more than learning the location for these settings. While Microsoft made it easier to discover this command, it only offers the Password to Open, not the Password to Modify. Why is my outcome different than yours? When I run the macro, I have to type the password in each instance, ie 20 or more times for 2 or more files. You'll learn what that protection does and doesn't do for you and how to avoid some gotchas.
This was on excel 2008 on a macbook. Whether you want other people to edit your excel workbook without permission? Here's the deal: A user without the modifying password can still view, modify, and save changes, if the user can get in. If you have to enter a password to open the document then you have not successfully set the document up for Read Only access. What I have already done is I have a worksheet, which is not visible that holds all user names, passwords and user roles, such as admin and user. How to secure an Excel worksheet with a password Brandon Vigliarolo walks you through the steps of securing an Excel worksheet with a password in Microsoft Office 365.
If you want to modify this Excel file, click on No to open it. The above code returns false in this instance, i guess because the workbook path has a. You can change workbook and save changes this time. Otherwise, you just could let excel file read-only all the time. The macro works just fine in opening the files and whatnot, but for some reason it prompts me to enter the password again once the file has been opened. 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. Save excel file and read-only mode would be removed from excel file.
Or the server the document is stored on may not be responding. My primary objection to the password approach is that I have to remember that it's blank. It is a white square on my desktop now with no options to do anything, it cannot even be attached to an email or deleted. Doing so won't defeat specialized software, but it will slow it down and that delay might cause the would-be cracker to put your workbook aside. Either of the case the file should be skipped without a warning message and any attempt to open. Now, this post will show you how to achieve that. Jaynet Zhang TechNet Community Support.
I cannot post my workbook because of the Corporate Copyrights and privacy, but what I can do is post all named ranges that contain password, usernames etc. 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. When I try this on any other computer it opens the spreadsheet without giving the option to edit with a password. They will allow me only to view the sheets - No editing, copy, cut, sort, add filter, etc. I get a run-time error '3161'.
In essence, I want to do the same thing as setting the read-only bit for a file, but I want to do it for an Excel 2010 worksheet. Jul 25, 2012 I am having an issue with a macro to open password protected workbooks. Add passwords if you want Excel to prompt for a password before allowing a user to open or modify the workbook file. By not setting a password it will not prompt you for a password if you want to unprotect it. Earlier this week, I password protected the spreadsheet. In fact, thanks to default values, you can drop everything on that line after.
I just know that I am not the only being on the planet who wants to do this. Microsoft designed Excel with an optional feature that prompts users to view a workbook in a read-only mode and save edits under a different file name. But I think some options you have used to set excel workbook read only, would be able to remove this setting always. It doesn't appear to be locked. 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.
So I want to have most people open it as read only and two of us use a password to edit the same spreadsheet. Apr 2, 2007 I have about 20 files that all have separate passwords. It is the worst thing to happen to me, and that includes my divorce. Please mention the app and version that you're using. It means you have disabled read-only in Excel file. Im usually ok with spreadsheets and have been stumped by this one!. I'm using Office 365 Excel desktop , but you can user earlier versions.
If you want to modify the Excel file, here will show you to make it editable. Remind yourself that you don't want to edit this sheet If it's to prevent yourself from accidentally editing the sheet, one solution is to draw giant rectangle that covers all your data and set it's transparency to 100%. Next time you can open the Excel file without a password. Please can anyone advise if I make changes and save them down, will this update the data in the read-only versions or will the users have to re-open the file to keep checking for changes? Is there a way of identifying the password?? A user who doesn't know the second password can open and view the data by clicking the Read Only option, but it's Read-Only—sort of. 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.