Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am using Excel 2003.
I am attempting to protect only certain cells within an Excel worksheet. I first click on FORMAT, CELLS, and "deselect" the "LOCKED" check box. I then highlight the cells I wish to protect, repeat that step, only this time make sure the LOCKED check box is checked. I then go to to TOOLS, PROTECTION, PROTECT SHEET, and attempt to select the option, and JUST the option for "Select locked cells", however, everytime I select this option, a checkmark appears next to "Select unlocked cells" as well. One seems to trigger the other. The net effect is that the WHOLE worksheet becomes locked instead of just the protected cells. Has anyone else experienced this problem and/or know of a solution? Thankyou |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
In excel can you select certain cells which contain the same text | Excel Discussion (Misc queries) | |||
Viewing LOCKED cells | Excel Discussion (Misc queries) | |||
How do I select a range if one cells contents is equal to another | Excel Discussion (Misc queries) | |||
how can i select all the cells with same color on a sheet if there are multipale colors by vba code | Charts and Charting in Excel | |||
Protected cells -automatically format to a different color | Excel Discussion (Misc queries) |