Worksheet Protection

[Guest]

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]

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.