Howto: Protecting specifig Ranges for inserting Rows

M

MarkusPoehler

Hi
I would like to protect specific Ranges of my Sheet. The users should be
able to edit specific CELLS and additionally EDIT cells and INSERTnew Rows
intos a specific predefined RANGE. But users should not be able to add Rows
in the other parts of the Sheet.

Do you know its possible? How to realize that?
 
B

Bernie Deitrick

Markus,

If you use a multi-cell array entered formula, Excel will prevent row
insertion (or column insertion) within that range.

For example, select A1:A10, type =ROW(), then press Ctrl-Shift-Enter. Then
select a cell in, say, row 8 and try to insert a new row: Excel will
protest, and prevent the row insertion.

HTH,
Bernie
MS Excel MVP
 
Top