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

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
 
E

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

VBA for worksheet change (add row) event (I think) 1
How to protect some cells, but able to insert rows elsewhere? 6
Excel 2002: How to conditional format a row of cells ? 2
How to delete the content of all unlocked cells in a protected she 1
need to modify a macro to prevent it from executing if in wrong area of the sheet 3
Total Row Not Calculating Correctly 2
Hiding & Unhiding Cells, How to 3
copy a range of cells (a row) to the bottom of a "list" 1

Top