Hi,

I have a workbook that has 52 protected sheets. In the data entry area
(which is not protected), I would like to create a macro so that at the touch
of a button, a new row is inserted and it will copy all the formulas down
from the row above. There are 6 rows containing formulas D, Q (these two
are hidden columns), R, S, T & U.

The first time this is run the row will be inserted after row 125 and the
next time after row 126 and so on.

I had a go at recording a macro which took the protection off the sheet,
unhid the columns D & Q inserted a row, copied down the formulas, rehid the
columns and reprotected the sheet.

Something went horribly wrong as it hid all of my columns up to Z.

Can anyone offer me some help.

Many thanks....

Maybe you can start with the procedure that David McRitchie shares:
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
look for: InsertRowsAndFillFormulas

Sal wrote:

Hi,

I have a workbook that has 52 protected sheets. In the data entry area
(which is not protected), I would like to create a macro so that at the touch
of a button, a new row is inserted and it will copy all the formulas down
from the row above. There are 6 rows containing formulas D, Q (these two
are hidden columns), R, S, T & U.

The first time this is run the row will be inserted after row 125 and the
next time after row 126 and so on.

I had a go at recording a macro which took the protection off the sheet,
unhid the columns D & Q inserted a row, copied down the formulas, rehid the
columns and reprotected the sheet.

Something went horribly wrong as it hid all of my columns up to Z.

Can anyone offer me some help.

Many thanks....

--

Dave Peterson

Hi Dave,

Many thanks, it has worked a treat.



"Dave Peterson" wrote:

Maybe you can start with the procedure that David McRitchie shares:
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
look for: InsertRowsAndFillFormulas

Sal wrote:

Hi,

I have a workbook that has 52 protected sheets. In the data entry area
(which is not protected), I would like to create a macro so that at the touch
of a button, a new row is inserted and it will copy all the formulas down
from the row above. There are 6 rows containing formulas D, Q (these two
are hidden columns), R, S, T & U.

The first time this is run the row will be inserted after row 125 and the
next time after row 126 and so on.

I had a go at recording a macro which took the protection off the sheet,
unhid the columns D & Q inserted a row, copied down the formulas, rehid the
columns and reprotected the sheet.

Something went horribly wrong as it hid all of my columns up to Z.

Can anyone offer me some help.

Many thanks....

--

Dave Peterson