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

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