Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Worksheet Protection
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. |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
protection of your worksheet | Excel Worksheet Functions | |||
Prevent unhide of rows/columns w/out worksheet protection? | Excel Discussion (Misc queries) | |||
Worksheet tab protection | Excel Discussion (Misc queries) | |||
copyright and worksheet protection | Excel Discussion (Misc queries) | |||
Seeking help for total worksheet protection | Excel Discussion (Misc queries) |