I have a spread sheet that I use for my staff. I have protected all of the
cells that have formulas because they keep going in and deleting them. They
are allowed to insert rows when their client base increases. However, when
they insert a row the formula does not copy into the inserted row. They can
not copy and paste because it is protected. So at the end of each month I
have unprotect each workbook and repaste the formula into the inserted rows.
The overall numbers and tracking are off until I do this. Is there a way to
make the formula's copy when a row is inserted and not allow them to screw up
the rest of the formulas?
--
Lisa M.