Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding row's with formula
How can I allow users to insert row's with the formula added automaticly
without unprotecting sheet regards Chris |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding row's with formula
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+PAllow 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! -------------------- (Ms-Exl-Learner) -------------------- "Chris" wrote: How can I allow users to insert row's with the formula added automaticly without unprotecting sheet regards Chris |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding row's with formula
How do I do a macro for this. I have NEVER done one before.
Thanks Chris "Ms-Exl-Learner" wrote: 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+PAllow 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! -------------------- (Ms-Exl-Learner) -------------------- "Chris" wrote: How can I allow users to insert row's with the formula added automaticly without unprotecting sheet regards Chris |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding row's with formula
Chris,
I too dont 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! -------------------- (Ms-Exl-Learner) -------------------- "Chris" wrote: How do I do a macro for this. I have NEVER done one before. Thanks Chris "Ms-Exl-Learner" wrote: 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+PAllow 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! -------------------- (Ms-Exl-Learner) -------------------- "Chris" wrote: How can I allow users to insert row's with the formula added automaticly without unprotecting sheet regards Chris |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding row's with formula
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 On Tue, 22 Dec 2009 01:29:01 -0800, Chris wrote: How do I do a macro for this. I have NEVER done one before. Thanks Chris "Ms-Exl-Learner" wrote: 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+PAllow 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! -------------------- (Ms-Exl-Learner) -------------------- "Chris" wrote: How can I allow users to insert row's with the formula added automaticly without unprotecting sheet regards Chris |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding row's with formula
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" wrote: 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 On Tue, 22 Dec 2009 01:29:01 -0800, Chris wrote: How do I do a macro for this. I have NEVER done one before. Thanks Chris "Ms-Exl-Learner" wrote: 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+PAllow 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! -------------------- (Ms-Exl-Learner) -------------------- "Chris" wrote: How can I allow users to insert row's with the formula added automaticly without unprotecting sheet regards Chris . |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding row's with formula
Run time Error 28, out of stack space. Comes up.
"Chris" wrote: 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" wrote: 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 On Tue, 22 Dec 2009 01:29:01 -0800, Chris wrote: How do I do a macro for this. I have NEVER done one before. Thanks Chris "Ms-Exl-Learner" wrote: 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+PAllow 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! -------------------- (Ms-Exl-Learner) -------------------- "Chris" wrote: How can I allow users to insert row's with the formula added automaticly without unprotecting sheet regards Chris . |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding row's with formula
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 InsertModule. 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 ToolMacroMacros. You can also assign this macro to a button or a shortcut key combo. Gord On Tue, 22 Dec 2009 22:01:02 -0800, Chris wrote: Run time Error 28, out of stack space. Comes up. "Chris" wrote: 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" wrote: 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 On Tue, 22 Dec 2009 01:29:01 -0800, Chris wrote: How do I do a macro for this. I have NEVER done one before. Thanks Chris "Ms-Exl-Learner" wrote: 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+PAllow 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! -------------------- (Ms-Exl-Learner) -------------------- "Chris" wrote: How can I allow users to insert row's with the formula added automaticly without unprotecting sheet regards Chris . |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding row's with formula
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. "Gord Dibben" wrote: 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 InsertModule. 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 ToolMacroMacros. You can also assign this macro to a button or a shortcut key combo. Gord On Tue, 22 Dec 2009 22:01:02 -0800, Chris wrote: Run time Error 28, out of stack space. Comes up. "Chris" wrote: 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 opened 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" wrote: 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 On Tue, 22 Dec 2009 01:29:01 -0800, Chris wrote: How do I do a macro for this. I have NEVER done one before. Thanks Chris "Ms-Exl-Learner" wrote: 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+PAllow 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! -------------------- (Ms-Exl-Learner) -------------------- "Chris" wrote: How can I allow users to insert row's with the formula added automaticly without unprotecting sheet regards Chris . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
row's won't unhide | Excel Discussion (Misc queries) | |||
merge of two row's into one row | Excel Discussion (Misc queries) | |||
copy row's value | Excel Discussion (Misc queries) | |||
Ranking/Sorting more than 3 row's | Excel Discussion (Misc queries) | |||
Sorting and Header Row's | Excel Discussion (Misc queries) |