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

K

Kris7635

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.
 
J

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.
 
Top