Can you protect a column and still be able to add a line?

[Guest]

I have a payroll spreadsheet with multiple formulas. I must protect those
formulas from users. I tried protecting the columns, but when I went to add
a new line for a new employee, it wouldn't let me.

Then I thought I would put the formulas on another sheet, but again, if I
add a new employee line then the information will not copy over.

Help?? Anyone?? I am on a short deadline.

 

[Jim Rech]

I'd suggest providing plenty of empty rows for new employees so that rows do
not have to be inserted. If that is not what you want I think you're going
to have to write a macro that removes protection, does the inserts and
copying of formulas, and re-protects the sheet.

--
Jim Rech
Excel MVP
|I have a payroll spreadsheet with multiple formulas. I must protect those
| formulas from users. I tried protecting the columns, but when I went to
add
| a new line for a new employee, it wouldn't let me.
|
| Then I thought I would put the formulas on another sheet, but again, if I
| add a new employee line then the information will not copy over.
|
| Help?? Anyone?? I am on a short deadline.