How to allow inserting cells (moving cells down) but not total row

[KReto]

Hi,

In my protected Excel sheet I would like users to be able to insert cells to certain columns without letting them insert entire rows. I want to prevent them to insert rows because in some hidden columns I have formulas which would not be added to the new rows...

So I would want to give authorisation to add cells in between row 1 & 2 in column A & B, but not in C.

	A	B	C
1	Volume	Price	= Volume*Price - automatic formula
2	Volume	Price	= Volume*Price - automatic formula
3			= Volume*Price - automatic formula
4			= Volume*Price - automatic formula

<tbody>
</tbody>

Thank you in advance,

Kim

 

[shanesuzanne]

I had something similar. I ended up converting the range to a table, and added a button that the user would click to add a new row that triggered a macro. The macro unprotected the sheet, added a new row to the table, then re-protected the sheet, and selected the new blank row so it was ready for user input. Since it's a table, the formulas automatically populate.

Otherwise, if you want to keep it as a normal range, you could add a macro that automatically populates the formula for you according to the last row in the range.