Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Password Cell Protection
Morning all.
I'm seeking to protect specific cells within a given worksheet. I've been reading some of the newer posts on the topic, and see that I'm to first go in, unlock cells that I want accessible, and then once all cells are configured- locked or unlocked state- I go to the Review Tab, select Protect Sheet, choose the options I want users to have access to, and select/enter the desired password- twice. Once I do this, all appears to be as desired, until I try to insert or delete a row-- something I'd specifically allowed for on my unlocked cells/rows. It doesn't matter if I try to select the entire row, or just a few cells. And yes, I do have locked cells above, and below my unlocked rows/cells. Are the locked cells below what's preventing my inserting more rows? Or....? Thank you. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Password Cell Protection
Normal behaviour is you can insert rows anywhere on the sheet when set to
"allowed". Locked cells above and below will not prevent insertion. Right-click on a row header and "Insert" But you cannot delete rows if even one cell in that entire row is locked. Gord Dibben MS Excel MVP On Tue, 5 Jan 2010 09:44:01 -0800, Steve wrote: Morning all. I'm seeking to protect specific cells within a given worksheet. I've been reading some of the newer posts on the topic, and see that I'm to first go in, unlock cells that I want accessible, and then once all cells are configured- locked or unlocked state- I go to the Review Tab, select Protect Sheet, choose the options I want users to have access to, and select/enter the desired password- twice. Once I do this, all appears to be as desired, until I try to insert or delete a row-- something I'd specifically allowed for on my unlocked cells/rows. It doesn't matter if I try to select the entire row, or just a few cells. And yes, I do have locked cells above, and below my unlocked rows/cells. Are the locked cells below what's preventing my inserting more rows? Or....? Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Password protection in macro ( Anybody can view my password in VB | Excel Discussion (Misc queries) | |||
Excel Data Protection- AKA: Sheet/Macro Password Protection | Setting up and Configuration of Excel | |||
Password for cell protection within VBA | Excel Worksheet Functions | |||
Password Protection - paste to unprotected cell locks the cell | Excel Discussion (Misc queries) | |||
Cell Password Protection-Multiple Worksheets | Excel Worksheet Functions |