how do I insert row keeping formulas from previous row?


T

Todd108

I've developed a protected sheet in excel 2003. I have protection set to
allow inserting rows. Unfortunately, the inserted row doesn't have formulas
of columns from previous row. Any way to do this?

Because what happens is users simply unprotect the sheet, and then copy and
insert rows in order to keep formulas intact in the inserted row. Of course
I don't want them unprotecting the sheet because then they can reek havoc.

Advice? Many thanks
 
Ad

Advertisements

D

Dave Peterson

You could give them a macro that would unprotect the worksheet, insert a new
row, copy|paste the values and formulas to the new row, delete the values in
that new row (if you want) and then reprotect the sheet.

If you want to try, start at David McRitchie's site:
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
look for: InsertRowsAndFillFormulas

If you're new to macros:

Debra Dalgleish has some notes how to implement macros here:
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top