Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Is it possible to group parts with controls?
I created a setup sheet with controls on it. I want to group (collapse) one
portion of it which will not always be used. I tried to group it but the controls did not go away when the rows were collapsed. Is it not possible to do this? I played with unlocking them, then in properties I don't have the option to move and size with cells. It's dimmed out. |
#2
|
|||
|
|||
I don't know what controls you're using, but sometimes if you use the similar
controls from the control toolbox toolbar, you'll see that move and size is available--checkboxes, for example. omnetws wrote: I created a setup sheet with controls on it. I want to group (collapse) one portion of it which will not always be used. I tried to group it but the controls did not go away when the rows were collapsed. Is it not possible to do this? I played with unlocking them, then in properties I don't have the option to move and size with cells. It's dimmed out. -- Dave Peterson |
#3
|
|||
|
|||
Thanks,
I am using a few options buttons, drop down lists, and a few spinners: http://img.photobucket.com/albums/v482/Ready/cntrls.jpg Does this help? |
#4
|
|||
|
|||
If this can't be done. I could just make a separate sheet for each portion
of (qualify, semifeature, and feature), but less sheets would be better :O) |
#5
|
|||
|
|||
I think you should do a little experimentation.
Try looking at one of each type to see if it supports the "move and size". If it doesn't, then add the control that's like it from the control toolbox toolbar. Then look to see if that supports "move and size". It shouldn't take too long to check 3 shapes. omnetws wrote: Thanks, I am using a few options buttons, drop down lists, and a few spinners: http://img.photobucket.com/albums/v482/Ready/cntrls.jpg Does this help? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Not sure which function and how to use it. Help | Excel Worksheet Functions | |||
Calculate cell row and column | Excel Discussion (Misc queries) | |||
Need help w/ Weight Formula | Excel Discussion (Misc queries) | |||
Can't group pivot table items by month in Excel | Excel Discussion (Misc queries) | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |