Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Grouping | Excel Worksheet Functions | |||
Grouping | Excel Worksheet Functions | |||
Grouping | Excel Discussion (Misc queries) | |||
Grouping | Excel Discussion (Misc queries) | |||
grouping | New Users to Excel |