Combo Boxes not being hidden when data grouping is collapsed

MarkVMcCullagh

MarkVMcCullagh

Board Regular
Joined
Oct 22, 2002
Messages
72
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.
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
Sort by date Sort by votes
I think that you should change the Object Positioning Property to "Move and size with cells" .The first option. It may works.

Niki
 
Upvote 0
I'm replying from memory as I don't have Excel on this machine. Unfortunately I think that option is greyed out. :(
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question
EXCEL VBA Combo box filter not working with numerical value but does with text value
Replies
0
Views
321
jocotterellash
J
Z
  • Question
Show/Hide Shape conditionally
Replies
0
Views
749
ZPar
Z
WildBurrow
  • Question
Copy/Paste data to next empty row within a range - WITHOUT shifting subsequent rows up
Replies
0
Views
113
WildBurrow
WildBurrow
A
  • Solved
Make rows (dis)appear with activeX checkbox
Replies
1
Views
772
axelg
A
U
  • Question
Information overwriting when transferring
Replies
7
Views
260
UTB
U

Forum statistics

Threads
1,215,053
Messages
6,122,882
Members
449,097
Latest member
dbomb1414

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top