Object A case-sensitive password for the worksheet.
Inserting new hyperlinks, even in unlocked cells. Delete columns Deleting columns. If Delete columns is protected and Insert columns is not also protected, a user can insert columns that he or she cannot delete.
Delete rows Deleting rows. If Delete rows is protected and Insert rows is not also protected, a user can insert rows that he or she cannot delete. Users can't sort ranges that contain locked cells on a protected worksheet, regardless of this setting.
Use AutoFilter Using the drop-down arrows to change the filter on ranges when AutoFilters are applied. Users cannot apply or remove AutoFilters on a protected worksheet, regardless of this setting.
Use PivotTable reports Formatting, changing the layout, refreshing, or otherwise modifying PivotTable reports, or creating new reports. Edit objects Doing any of the following: Making changes to graphic objects including maps, embedded charts, shapes, text boxes, and controls that you did not unlock before you protected the worksheet.
For example, if a worksheet has a button that runs a macro, you can click the button to run the macro, but you cannot delete the button.
Making any changes, such as formatting, to an embedded chart. The chart continues to be updated when you change its source data. Adding or editing comments. Edit scenarios Viewing scenarios that you have hidden, making changes to scenarios that you have prevented changes to, and deleting these scenarios.
Users can change the values in the changing cells, if the cells are not protected, and add new scenarios.
Chart sheet elements To prevent users from Contents Making changes to items that are part of the chart, such as data series, axes, and legends. The chart continues to reflect changes made to its source data.
In the Password to unprotect sheet box, type a password for the sheet, click OK, and then retype the password to confirm it. The password is optional. If you do not supply a password, any user can unprotect the sheet and change the protected elements. Make sure that you choose a password that is easy to remember, because if you lose the password, you won't have access to the protected elements on the worksheet.
Unlock ranges on a protected worksheet for users to edit To give specific users permission to edit ranges in a protected worksheet, your computer must be running Microsoft Windows XP or later, and your computer must be in a domain.
Instead of using permissions that require a domain, you can also specify a password for a range. Select the worksheet that you want to protect. This command is available only when the worksheet is not protected. Do one of the following: To add a new editable range, click New.
To modify an existing editable range, select it in the Ranges unlocked by a password when sheet is protected box, and then click Modify.
To delete an editable range, select it in the Ranges unlocked by a password when sheet is protected box, and then click Delete.
In the Title box, type the name for the range that you want to unlock. You can also click the Collapse Dialog button, select the range in the worksheet, and then click the Collapse Dialog button again to return to the dialog box.
For password access, in the Range password box, type a password that allows access to the range. Specifying a password is optional when you plan to use access permissions. Using a password allows you to see user credentials of any authorized person who edits the range. For access permissions, click Permissions, and then click Add.
In the Enter the object names to select examples box, type the names of the users who you want to be able to edit the ranges.Feb 10, · The tutorial shows how to protect Excel sheet with or without passwords.
It also explains how to unlock Excel spreadsheet without password if you forgot or misplaced it.
Unlock Excel spreadsheet with VBA code (for Excel and lower) How to hide and lock formulas in Excel; How to edit, evaluate and debug formulas in Excel. Ujna Technologies has shown you how to protect a worksheet and thereby prevent the user from entering data in a Locked cell.
Most people would use this approach. Protect with a macro. It is also possible to protect a cell using VBA code. The snippet below contains code protecting cell D3 from changes. I have this excel sheet where i want to protect some cells from formating and editing. All these cells are colored with a specific color.
The sheet is very big and therefor i am looking for a way to lock all these cells in a go and then be able to mass format all the other cells without changing the cells that i want to lock.
VBA Code to Password Protect an Excel file Password protecting an Excel file achieves two main objectives (1) prevents unauthorized access to the Excel file (2) prevents unauthorized modification of the Excel file. Then, hide the column or row that contains the linked cell, or move the contents of the linked cell to a separate worksheet, and then hide that worksheet.
For more information, see Hide or display rows and columns and Hide or display worksheets or workbooks. This is sort of a followup to my previous question.
I want to protect a range of cells, then unprotect them so I can create a new worksheet by copying and pasting the original, then re-protect the original worksheet and the new, copied worksheet.