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 |
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 |
All times are GMT +1. The time now is 03:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com