grouping

[steve]

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

[steve]

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

[JE McGimpsey]

See David McRitchie's INSRTROW macro:

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


In article <[email protected]>,
"steve" <[email protected]> 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?