Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Copy/Paste a protected cell
If I have a worksheet that is protected and I have allowed a user to insert
rows, is there any way to also allow the user to drag down the formula from the above cell? |
#2
|
|||
|
|||
If you unlock the cells in that column, then protect the worksheet, your users
can drag down--and also change everything else in that column. You may want to use a macro that unprotects the sheet, inserts the row, copies formulas, and reprotects the worksheet. If you want to try that, take a look at David McRitchie's macro: http://www.mvps.org/dmcritchie/excel/insrtrow.htm look for: InsertRowsAndFillFormulas Nat1 wrote: If I have a worksheet that is protected and I have allowed a user to insert rows, is there any way to also allow the user to drag down the formula from the above cell? -- Dave Peterson |
#3
|
|||
|
|||
Thanks Dave:
I can't get the macro to work yet. But I think if I play with it. It should do what I need it to do. Thanks for your help. "Dave Peterson" wrote: If you unlock the cells in that column, then protect the worksheet, your users can drag down--and also change everything else in that column. You may want to use a macro that unprotects the sheet, inserts the row, copies formulas, and reprotects the worksheet. If you want to try that, take a look at David McRitchie's macro: http://www.mvps.org/dmcritchie/excel/insrtrow.htm look for: InsertRowsAndFillFormulas Nat1 wrote: If I have a worksheet that is protected and I have allowed a user to insert rows, is there any way to also allow the user to drag down the formula from the above cell? -- Dave Peterson |
#4
|
|||
|
|||
If you don't get it working, you may want to post back with your current code
and indicate the problem. Nat1 wrote: Thanks Dave: I can't get the macro to work yet. But I think if I play with it. It should do what I need it to do. Thanks for your help. "Dave Peterson" wrote: If you unlock the cells in that column, then protect the worksheet, your users can drag down--and also change everything else in that column. You may want to use a macro that unprotects the sheet, inserts the row, copies formulas, and reprotects the worksheet. If you want to try that, take a look at David McRitchie's macro: http://www.mvps.org/dmcritchie/excel/insrtrow.htm look for: InsertRowsAndFillFormulas Nat1 wrote: If I have a worksheet that is protected and I have allowed a user to insert rows, is there any way to also allow the user to drag down the formula from the above cell? -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List, Data Validation, unlocked cell, protected sheet..... | New Users to Excel | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
How do you shade in an unlocked cell on a protected worksheet? | Excel Discussion (Misc queries) | |||
Protected Cell | Excel Worksheet Functions | |||
CELL PROTECTED IN 2000, UNPROTECTED IN 2003 | Excel Worksheet Functions |