grouping
 

First of all, i just wanted to thank all of you guys who help us out on here.
i've learned more in a month with this site then i did all through school..

but anyway, i have a sheet that has a bunch of groups. i want the sheet
protected so it can't get messed up, but i also want the user to be able to
open and close the groups. (i had it set up with the Data -- Group Rows).
is this possible without unprotecting the sheet?

with my command buttons, i just embed it in the code to unprotect sheet,
then protect it again at the end of the sub. but with grouping, i do not
have a button. also, there is not an option when you protect the sheet to
"allow user to group"

thanks guys

grouping
 

i'm sorry, i just found my answer somewhere else on the site, thank you

one other quick question...
i want to be able to insert a row with the same exact formulas as the row
above it. basically, i have a group of rows that are for one job. if i
insert a row, i need all the formulas to be exactly the same. the problem i
am having is that it copies all of the formulas, but it references different
cells. i understand that it thinks i want it to do that, but i really need
it to keep the same exact formula referencing the same cells. how can i go
aobut this?

the jist of it is that the size of a project may grow, so i need to insert
more rows for it. i want to be able to do it without typing in formulas
again (i.e. through a button that inserts a row based on which row is
selected or whatever)

thanks


all of the jobs



"steve" wrote:

First of all, i just wanted to thank all of you guys who help us out on here.
i've learned more in a month with this site then i did all through school..

but anyway, i have a sheet that has a bunch of groups. i want the sheet
protected so it can't get messed up, but i also want the user to be able to
open and close the groups. (i had it set up with the Data -- Group Rows).
is this possible without unprotecting the sheet?

with my command buttons, i just embed it in the code to unprotect sheet,
then protect it again at the end of the sub. but with grouping, i do not
have a button. also, there is not an option when you protect the sheet to
"allow user to group"

thanks guys

grouping
 

See David McRitchie's INSRTROW macro:

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


In article ,
"steve" wrote:

i want to be able to insert a row with the same exact formulas as the row
above it. basically, i have a group of rows that are for one job. if i
insert a row, i need all the formulas to be exactly the same. the problem i
am having is that it copies all of the formulas, but it references different
cells. i understand that it thinks i want it to do that, but i really need
it to keep the same exact formula referencing the same cells. how can i go
aobut this?