Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
group of rows and element
Hello!
I have the following problem: I have 5 rows, in one of them, there is an element (a combobox). I make a group of the five rows. Now when I click on the "-"sign to hide the rows, the combobox does not get hidden and stays on the excel-sheet. Does anybody know how I can manage this problem? In my excel-options I have activated the checkbox that objects should be copied and cut out with cells, and this works (for example when I cut out the row with the element and insert it somewhere the combobox is included in this process). Thanks for your help. Regards Christian |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
group of rows and element
Hi Christian,
It seems with some, but not all, of controls from the "Forms" menu it's not possible to change the "Move or size with cells" property in Format Control. And that's the property you need to check to make the object disappear when you click the "-" outline. However it is possible to set this property with an active-x Combobox from the "Controls Toolbox" menu. So use a Controls toolbox combobox and link your code to its change event in the worksheet module (right click the combobox and View Code). Regards, Peter T "Christian Galbavy" wrote in message ... Hello! I have the following problem: I have 5 rows, in one of them, there is an element (a combobox). I make a group of the five rows. Now when I click on the "-"sign to hide the rows, the combobox does not get hidden and stays on the excel-sheet. Does anybody know how I can manage this problem? In my excel-options I have activated the checkbox that objects should be copied and cut out with cells, and this works (for example when I cut out the row with the element and insert it somewhere the combobox is included in this process). Thanks for your help. Regards Christian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Group rows (or hide rows) like in MS Project | Excel Worksheet Functions | |||
group rows between blank rows | Excel Discussion (Misc queries) | |||
group rows | Excel Discussion (Misc queries) | |||
Delete rows with common element | Excel Programming | |||
"for each element in group" question | Excel Programming |