Combo Boxes not being hidden when data grouping is collapsed

[MarkVMcCullagh]

Hi there.

I'm using Excel 2003 and Ive got 2 combo boxes that appear in rows 3 & 5 respectively of my worksheet. Rows 3-12 have been grouped using Data Grouping. My problem is on collapsing the grouping to hide rows 3 to 12 the rows are collapsed alright but both combo boxes are pushed down to row 13 instead of being hidden. The Object Positioning Property says "Move but don't size with cells".

Any ideas on how I sort this? Thanks in advance.

 

[nikkki]

I think that you should change the Object Positioning Property to "Move and size with cells" .The first option. It may works.

Niki

 

[MarkVMcCullagh]

I'm replying from memory as I don't have Excel on this machine. Unfortunately I think that option is greyed out.

 

[Datsmart]

You are correct. That is not an option for a Forms ComboBox.