Adding row's with formula

[Chris]

How can I allow users to insert row's with the formula added automaticly
without unprotecting sheet
regards
Chris

 

[Ms-Exl-Learner]

Like your previous post while protecting the worksheet check the Insert Rows
Checkbox and enter your protection password and give ok. So the users are
not required to unprotect the workbook for inserting rows.

Alt+T+P+P>>Allow All User of this Worksheet to:>>Check the Insert Rows check
box

About the filling of Formula to a newly added row should be done manually by
pressing Cntrl+D or you should go for macro solution.

Remember to Click Yes, if this post helps!

 

[Chris]

How do I do a macro for this. I have NEVER done one before.
Thanks
Chris

 

[Ms-Exl-Learner]

Chris,

I too don’t know anything about macro. Lots of experts are here and I hope
that they will help you in creating the macro.

Remember to Click Yes, if this post helps!

 

[Gord Dibben]

David McRithchie has done it for you.

http://www.mvps.org/dmcritchie/excel/insrtrow.htm

Scroll down to...................

Code for the InsertRowsAndFillFormulas Macro (#insrtrow)


Gord Dibben MS Excel MVP

 

[Chris]

I have entered' Insert_Rows_and_Fill_Formulas into "Record new macro", It
worked once and now it comes up Error 28, run time error. I closed the
spread sheet and didn't save it. I oppened it up and when I tried to enter it
again nothing happened. I have tried it on a blank spread sheet(x3) and the
one I am working with( x2), it only worked on the blank one the first time.
What have I done wrong.
Thanks
Chris

 

[Chris]

Run time Error 28, out of stack space. Comes up.

I have entered' Insert_Rows_and_Fill_Formulas into "Record new macro", It
worked once and now it comes up Error 28, run time error. I closed the
spread sheet and didn't save it. I oppened it up and when I tried to enter it
again nothing happened. I have tried it on a blank spread sheet(x3) and the
one I am working with( x2), it only worked on the blank one the first time.
What have I done wrong.
Thanks
Chris

 

[Gord Dibben]

Not sure why that particular error is arising.

Let's make sure you have things in the right place to start.

Since you're not familiar with VBA and macros, see David McRitchie's site
for more on "getting started".

http://www.mvps.org/dmcritchie/excel/getstarted.htm

or Ron de De Bruin's site on where to store macros.

http://www.rondebruin.nl/code.htm

In the meantime..........

First...create a backup copy of your original workbook.

To create a General Module, hit ALT + F11 to open the Visual Basic Editor.

Hit CRTL + r to open Project Explorer.

Find your workbook/project and select it.

Right-click and Insert>Module. Paste the code in there. Save the
workbook and hit ALT + q to return to your workbook.

Run or edit the macro by going to Tool>Macro>Macros.

You can also assign this macro to a button or a shortcut key combo.


Gord

 

[Chris]

Thanks Gord Dibben.
I have worked out what I was doing wronge. after entering the code and going
back to the sheet I would put in a password on protect. It was ok without the
password. As the code had the protect in it they must have been getting
confused as to witch comand to follow.