Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
password protect cells problem
Could be.
I'd unprotect the worksheet and make sure the cells I want locked are locked and the cells I want unlocked are unlocked. Tools|Protection|unprotect sheet select the range to lock format|cells|protection tab|check locked. Select the range to unlock and do the similar thing. Then reprotect the worksheet and test it. oxicottin wrote: I have an excel sheet that I password protected certain cells so data could be entered. I reciently incerted a few cells and went back threw and reselected the cells that I wanted password protected. Well the new cell I just incerted I wanted writeable and they are not but everything else is just fine. Could it be because I I inserted the cell next to one that was protected before? How do I fix this? Thanks!! -- Dave Peterson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating only non-empty cells... | Excel Worksheet Functions | |||
Validate MsgBox Entry to Data in Cells | Excel Discussion (Misc queries) | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Protecting Workbook | Excel Discussion (Misc queries) | |||
password protected certain cells in spreadsheet | Excel Discussion (Misc queries) |