Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
 
Posts: n/a
Default 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.
  #3   Report Post  
 
Posts: n/a
Default

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   Report Post  
 
Posts: n/a
Default

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   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Not sure which function and how to use it. Help Damon Johnson Excel Worksheet Functions 2 July 25th 05 11:09 PM
Calculate cell row and column Barb R. Excel Discussion (Misc queries) 7 May 2nd 05 07:02 PM
Need help w/ Weight Formula Tom Excel Discussion (Misc queries) 3 March 4th 05 05:23 PM
Can't group pivot table items by month in Excel scott_ensley Excel Discussion (Misc queries) 1 February 1st 05 08:41 PM
Subtotal of Subtotal displays Grand Total in wrong row Thomas Born Excel Worksheet Functions 5 January 6th 05 01:46 PM


All times are GMT +1. The time now is 02:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"