Require A Password To Open Or Modify A Workbook

1. Require A Password To Open Or Modify A Workbook Free
2. Set A Password To Open An Excel Spreadsheet

VBA Code to Password Protect an Excel file. Posted on September 22. ='modifyFilePassword' 'Save file with password required to open and modify the file ThisWorkbook.SaveAs Password:='fileOpenPassword. Block of codes. For example, this block of codes put it in module then this one for form load, and then this one is for workbook, etc.

At times you may want to restrict other users from making changes to an Excel workbook. This might come in handy, especially when you’ve prepared a report that is subject to evaluation and don’t want the figures to be manipulated. Deploying the Read-Only option to your workbook can help to lock it from unauthorized editing. To achieve that, you’ll need to create a password for that particular workbook. Protecting an Excel workbook with a password can work in two ways:. It can prevent unauthorized access to a workbook. It can also restrict users from modifying the contents of a spreadsheet (makes it read only).

In this post we’ll focus more on the latter. You can protect an Excel workbook with a password to make it read only.

This means users will be able to open the workbook and view the data but won’t be able to make any changes to the spreadsheet. Related: Save an Excel Workbook as Read Only Here’s a step-by-step guide on how to add a password to make your Excel workbook read only. Open the workbook and click the “File” option. Select the “Save As” option from the menu and click it.

The “Save As” dialogue box will pop up. Navigate to the bottom of the box and find the “Tools” option just next to the “Save” button. Click on “Tools” and a dropdown menu will open. Select and click “General options” in the dropdown menu. Doing so will open up the “General Options” dialogue box. This is where you’ll create a password for your workbook. Enter your desired password in the “Password to modify” box as illustrated below.

Check the box for “Read-Only recommended,” then click “OK.” 4. You’ll be prompted to confirm the password. Enter the same password, then click OK to complete the process. Lastly, click the “Save” button. Now every time a user attempts to open the workbook, a pop-up notification box will appear with the following message. Clicking the “Read-Only” button will open the document but in Read-Only mode. Only those you share the “password to modify” with will be able to make changes to the workbook.

How to Disable the Read-Only Feature on Your Workbook What if you want to lift the read-only restriction and grant everyone editing privileges? Removing the Read-Only feature is an easy process and can be done with just a click of a button. All you’ll need to do is go through the same process again and uncheck the box that makes your Excel workbook Read-Only. Once you’ve unchecked the box, remove the password that you had set and click “Save” to apply the new changes. The next time you open the workbook, it will not open in Read-Only mode, nor will it display the Read-Only restriction box.

Require A Password To Open Or Modify A Workbook Free

Wrapping Up Setting a password to open an Excel workbook is easy and self-explanatory. Nevertheless, it can give a great deal of control over who can access and/or edit a workbook. This can go a long way in maintaining data integrity.

I have a user, who has a protected workbook, and when she opens it, it asks for a password like normal. Recently a user apparently knew the password and was getting into the file who shouldn't be and should just be using read only for this particular file like everyone else, the user who modifies this document wanted the password changed. Seems easy enough right?

Well I have no 'UNPROTECT OPTION' under file permissions or under review protect workbook, sheet, etc, there is nothing. Where is it getting this password from? I even tried opening this in office 2007 and 2003 and the options are also not there to unprotect either, just protect. If I set a new password, it takes the new password but when I open the workbook the new password does not work, it still wants the old one. Even tried opening within open office and all of the protection options are grayed out.

Set A Password To Open An Excel Spreadsheet

Seriously confused. Put this code into Visual Basic under the spreadsheet form and run this code! Instant unlock Sub PasswordBreaker 'Breaks worksheet password protection.