Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automated formula coping
I have set up premission for editing data in a spreadsheet. It only allows
certain people to edit certain ranges. It also includes locked cells with formulas in. The permissions allow people to insert rows, and what I am wanting it to do is automatically copy the formulas to the inserted rows. Is this possible? Regards |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automated formula coping
Maybe you could provide a macro that would unprotect the worksheet, do the
insert (and copy over formulas), then reprotect the worksheet. David McRitchie has some code to insert rows and copy formulas at: http://www.mvps.org/dmcritchie/excel/insrtrow.htm look for: InsertRowsAndFillFormulas If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm TheRook wrote: I have set up premission for editing data in a spreadsheet. It only allows certain people to edit certain ranges. It also includes locked cells with formulas in. The permissions allow people to insert rows, and what I am wanting it to do is automatically copy the formulas to the inserted rows. Is this possible? Regards -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula for coping a cell from a diffent sheet | Excel Discussion (Misc queries) | |||
coping formula | New Users to Excel | |||
coping formula | New Users to Excel | |||
Coping a formula | Excel Discussion (Misc queries) | |||
Coping formula down | Excel Programming |