Password Cell Protection

S

Steve

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.
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste Value 1
Protection not allowing Validation 4
Word 97 Password 0
Need Help with a VBA subroutine 0
Locked cells 1
Protect Worksheet Macro 2
Protecting worksheet. 1
Worksheet Protection Question 1

Top