How to permit editing the contents of added row(cells) if previous row is protected?

  • Thread starter Thread starter EagleOne
  • Start date Start date
E

EagleOne

2007

Is there an approach to enable cell editing to the cells in an added row if the above cells are
locked and the w/s protected?

My point, can OK the addition of rows to a protected w/s.

That said, the cells in that new row cannot be edited because the inserted row (cells) inherits the
protection formatting characteristic from the cells above the inserted row.

TIA EagleOne
 
Another question:

Looking at the Properties Window of the VBA editor
I find a Property EnableFormatConditions = True or False

I cannot find an explanation as just what this property is.

Does anyone know that answer?

TIA EagleOne
 

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

How to protect some cells, but able to insert rows elsewhere? 6
Allowing row deletion in worksheet with locked cells 2
Protect worksheet - losing values 2
VBA for worksheet change (add row) event (I think) 1
Password Protection - paste to unprotected cell locks the cell 7
excel 2007 - how to insert row with formats and totals of previous 1
evaluting cell contents for "type" and add row if the cell is bla 2
How can I protect Cells containing a formula? 1

Back
Top