Allowing editing locked cells in a protected sheet in 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,
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
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
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?
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
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...
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.
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 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!
-Execute your own command
-100% Templates allowing full customization
-Unix based server. (Linux, Freebsd, BSDI, etc.)
-Ability to run CGI programs.
-Understanding of CGI Installation.
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.
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