You are here: HomeExcelTutorials
Facebook Twitter Reddit More...

Allowing editing locked cells in a protected sheet in excel

Allowing editing locked cells in a protected sheet in excel

Price: FREE

1. I have an protected excel sheet in which Columns A,B,C are locked and cannot be edited by everyone however columns D and E are open to be edited
2. However my problem is when I click on protect worksheet and add myself in the permissions tab to edit without password, I cannot edit and the whole sheet gets locked. This is not expected.

Visit publisher's web-site: Allowing editing locked cells in a protected sheet in excel

Category and Tags: ExcelTutorials :

Related Tutorials

Autofilter with Locked/Protected worksheets

Free: Yes
Tags: Excel ›

We use a system of monitoring duties using excel, with spreadsheets that are protected with passwords to modify by certain personnel.
The worksheets within are password protected to prevent deletion of formula in certain locked cells/columns. Other cells are not locked allowing editing by authorized users.
However, the autofilter function doesn't work (unless unprotected), which is essential to allow duty managers to filter out the staff quickly and effectively.
It will work with protected sheets if the contents tab is anticked when protecting the worksheets, but this then allows columns with formula in to be deleted, and is the whole reason for us protecting these cells and the formula.
Don't know what else to try,

Still can select locked cells in protected sheet

Free: Yes
Tags: Excel ›

When I protect a sheet, and the only action allowed is "Select unlocked cells", the user cannot select any locked cells, which is what I want.
When I save the sheet, and then reopen it, the user can select locked cells. It doesn't do him any good, since he can't alter the cell. If he tries, he gets an error message advising him that the cell is protected.
If I unprotect and re-protect the sheet, the behavior goes back to not even being able to select the locked cells.
Is there a way to ensure that behavior when the locked worksheet is

copy cells but lock editing

Free: Yes
Tags: Excel ›

I have a spreadsheet where I have locked cells and password protected.
within this sheet though I have not locked a specific range of cells as they are used in another sheet as source data.
Is there a way that I can allow these cells to still be copied for the source data but not actually changed by other users?
Thanks as always

Updating of a locked cell

Free: Yes
Tags: Excel ›

I have a worksheet protected because it is all formulas for calculations with other worksheets within the workbook. When I change one of the unprotected cells of a worksheet, I want the formula cell to "update". It will if it is not protected but the cell is locked and protected. How do I keep others from editing the formula if I can not have the cell locked/protected?

Still able to change cells that are locked & protected?

Free: Yes
Tags: Excel ›

I have an Excel 2007 spreadsheet with a combination of locked and unlocked cells. However, when I protect the spreadsheet I am still able to select and change the value of cells that are supposed to be locked.
I have confirmed that the cell format is set to "Locked" and the only options selected when I protect the sheet are "Select locked cells" and "Select unlocked cells".
Why am I still able to change the value in the cells that are supposed to be locked?

Related Applications & Scripts

Raw XML Editor with Hinting and Validation

Free: No
Tags: Flash › Excel Forms

This is an online editor for XML files. It edits the raw XML data, allowing for code hints and even XML validation. Please note, the preview file uses a shared object to save, so that you can get a true feel of the editing process. If I put the same file up for the preview as in the download (using PHP to edit the actual XML ), many people would be editing at the same time, and it would not give an accurate representation. Please see the features below...

Animus FAQGen : FAQ Generator

Free: Yes
Tags: PHP › Excel FAQs

This script lets you add a FAQ to your web page. Your visitors can use ask you questions through it, and you can answer those questions publicly or privately; or even with an answer that you've already given. It can be set up to match the look of your web site, so that it doesn't look weird, and can handle multiple FAQ pages.
Features
All configuration is done through an easy to use administration page, making this ideal for people who want to add functionality to their site but aren't the most technoligically litterate.
Supports multiple FAQs, allowing you to keep your website organized.
Allows you to fully modify any incoming questions for public display so that you're not at the mercy of the asker's spelling.
Permits editing, deleting, copying, and moving the position of any existing questions and answers.
In additon to allowing you to change all colors and use a .css file, this script allows you to add header and footer HTML, so that the FAQ fully matches the look of your site.

SimpleShell

Free: No
Tags: CGI and Perl › Excel Shell

SimpleShell allows you to execute your own command. This pretty package removes the handicap of not having telnet. Even if you do have telnet access this script can save you time and takes less effort!
Features
-Execute your own command
-100% Templates allowing full customization
-Password protected
Requirements
-Unix based server. (Linux, Freebsd, BSDI, etc.)
-Ability to run CGI programs.
-Understanding of CGI Installation.

Power XML Template

Free: No
Tags: Flash › Excel Web Layouts

Power XML template is the ultimate solution for creating, editing and launching your website in Adobe Flash, even if you do not know anything about the ActionScript language and you do not have a copy of the software. Through a simple modification of the XML file, you will be able to setup your main menu and footer, to use up to 7 predefined modules and, above all, to update your website on your own.
This template structure is quite complex, but it is very easy to use. Thanks to this guide, you will be able to use the template immediately, allowing you to learn over time the several possibilities offered by Power XML Template.

XML Accordion

Free: No
Tags: Flash › Excel Menus Vertical Menus

Each item in the xml has a title and a content attribute, allowing the flash file to load external contents into each item. The example above loads .jpg images, but these can be .swf, .png, .gif. (Basically any format allowed by Loader.load())
- Easy do edit xml file
- add as many items as your site can handle
- change which item opens by default
- clearly labeled layers and symbols for easy editing

© 2014 Contact us - Privacy Policy - Terms of use - Add Listing