Home > In Excel > How To Protect Certain Cells In Excel 2013

How To Protect Certain Cells In Excel 2013

Contents

current community chat Stack Overflow Meta Stack Overflow your communities Sign up or log in to customize your list. Format cells Changing any of the options in the Format Cells or Conditional Formatting dialog boxes. Users can change the values in the changing cells, if the cells are not protected, and add new scenarios. Objects Making changes to graphic objects — including shapes, text boxes, and controls — unless you unlock the objects before you protect the chart sheet. http://webjak.net/in-excel/how-to-lock-cells-in-excel-2010.html

Send No thanks Thank you for your feedback! × English (United States)‎ Contact Us Privacy & Cookies Terms of use & sale Trademarks Accessibility Legal © 2016 Microsoft Register Help Follow me on Twitter or Google Plus Copyright ©2016 · Focus Pro Theme on Genesis Framework · WordPress · Log in Send to Email Address Your Name Your Email Address Cancel Thanks in advance excel-vba share|improve this question asked Feb 7 '12 at 18:50 user793468 1,460105394 add a comment| 1 Answer 1 active oldest votes up vote 4 down vote accepted Even In the screenshot below, the selected cells -- A2:C6 -- should be unprotected, so users can enter data.

How To Protect Certain Cells In Excel 2013

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 reflect changes made to its source data. If prompted, type the password to unprotect the worksheet.

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. Use AutoFilter Using the drop-down arrows to change the filter on ranges when AutoFilters are applied. Delete rows Deleting rows. Excel Lock Cells From Editing By default, users are allowed to select locked cells.

For password access, in the Range password box, type a password that allows access to the range. Thanks for any insight… Reply Mitch says: October 9, 2013 at 11:17 pm Thanks - this easily fixed my problem! To specify the type of permission for the user who you selected, in the Permissions box, select or clear the Allow or Deny check boxes, and then click Apply. Not the answer you're looking for?

Format rows Using any of the row formatting commands, including changing row height or hiding rows (Home tab, Cells group, Format button). How To Protect Cells In Excel 2016 Uncheck the box for "Locked" to unlock the cells. Do one of the following: To add a new editable range, click New. The chart continues to be updated when you change its source data.

How To Protect Cells In Excel 2010 Without Protecting Sheet

In the Password to unprotect sheet box, type a password, click OK, and then retype the password to confirm it. How can we improve it? How To Protect Certain Cells In Excel 2013 Delete rows Deleting rows. How To Protect Formulas In Excel Members List Calendar Forum Rules Dashboard Commercial Services Advanced Search Forum Microsoft Office Application Help - Excel Help forum Excel General [SOLVED] unable to unprotect my protected excel file To get

which means by right it should be an unprotected file. this contact form 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. Format cells Changing any of the options in the Format Cells or Conditional Formatting dialog boxes. You're post is tagged excel-vba, so I'll mention that you can protect the sheet in code using UserInterfaceOnly:=True and then you can do all of the above using VBA: Activesheet.Protect userinterfaceonly:=True, How To Freeze Cells In Excel

If a cell belongs to more than one range, users who are authorized to edit any of those ranges can edit the cell. Please try the request again. Keyboard shortcut  You can also press CTRL+1. have a peek here Remember that locking and unlocking cells has no effect unless you protect the sheet. 2: Allow special access A protected sheet is seriously limited.

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. How To Lock Cells In Excel 2007 You can unlock cells so users can update and/or enter new data (#1), but users will often need to do more than that. Learn more Close Sign in Search Microsoft Search Products Templates Support Products Templates Support Support Apps Access Excel OneDrive OneNote Outlook PowerPoint SharePoint Skype for Business Word Install Subscription Training Admin

The password is optional.

On the keyboard, press Ctrl + 1 to open the Format Cells dialog box. asked 4 years ago viewed 8567 times active 1 year ago Blog Stack Overflow Gives Back 2016 Related 0Using VBA to copy a Reference to a Cell from Sheet 2 to If you do not supply a password, then any user can unprotect the sheet and change the protected elements. Unlock Cells In Excel 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.

Watch the Video To see the steps for allowing changes in some cells on a protected Excel worksheet, please watch this short Excel video tutorial. Format columns Using any of the column formatting commands, including changing column width or hiding columns (Home tab, Cells group, Format button). Users can change the values in the changing cells, if the cells are not protected, and add new scenarios. Check This Out By default, users are allowed to select locked cells.

Edit objects Doing the 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 Format rows Using any of the row formatting commands, including changing row height or hiding rows (Home tab, Cells group, Format button). Note    This command is available only when the worksheet is not protected. This is a good way to hide intellectual and proprietary property in custom workbooks. (Excel doesn't hide cells by default.) 4: Allow programmatic updates and tasks If you're familiar with VBA,

Make sure that you choose a password that is easy to remember, because if you lose the password, you cannot gain access to the protected elements on the worksheet. In the Password to unprotect sheet box, type a password for the sheet, click OK, and then retype the password to confirm it. Any help is very much appreciated. Insert columns Inserting columns.

The rest of the cells should be protected, so the formulas cannot be changed or deleted. Edit scenarios Viewing scenarios that you have hidden, making changes to scenarios that you have prevented changes to, and deleting these scenarios. Click OK.