Cell Protection

  • Thread starter Thread starter Neil_Pattison
  • Start date Start date
N

Neil_Pattison

I have set up a spreadsheet for the materials that my company requires.


The problem I have is that I have locked a certain column of cells that
hold formulas so they cannot be deleted by mistake, but I want to be
able to insert rows in the middle of the list for any new materials
that come in.

Since each row has a protected cell in it, it won't allow me to do
this. Is there any way of getting around this so rows can be inserted
in the middle of the worksheet whilst keeping the protected cells and
also pulling the formula down from the row above.

Any help would be greatly appreciated.
 
Good evening Neil_Pattison

You don't state what version of Excel you you are using but XL2003 has
this functionality:
Tools > Protection > Protect Sheet and then check the Insert rows box.

HTH

DominicB
 
Hi Neil

No problem. Appreciate the feedback.

DominicB

Aaaaaaaaaarrrrrrghhhhhh - just noticed you're a Yorkshireman. Didn't
see that when I posted originally...............!!!!
 
You must log in or register to reply here.

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

Can't use protection options 1
Protecting a Sheet 7
Delete rows while sheet protected 3
How to permit editing the contents of added row(cells) if previous row is protected? 1
Sheet Protection 3
Auto fill formulae when inserting rows 9
Countif wrong in last row or two 3
Inserting Picture Into Protected Worksheet 1

Back
Top