I think I'd keep the worksheet protected and give the users a macro to do the
inserting of rows.
David McRitchie has some code you can steal.
He even shows how to copy the formulas, but clear out the constants.
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
look for: #insrtrow
If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
===
Essentially, you'll unprotect the worksheet, run David's code, and reprotect the
worksheet.
Krista wrote:
I currently have a large worksheet that is used by many to input data.
However I have some columns locked so the end user can not delete the
computed columns. However I need to allow the end user to add rows if
necessary. In the protection I checked off insert rows. However this
function is not working do to some of the column locks.
Example: Across the top of my worksheet I have the months listed and totals
by quarters for the year as they need to add a new row for a new customer.
I hope this makes sense and someone can offer me some help.
--
Dave Peterson