View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default CheckBoxes Stack up when Rows are hidden and unhidden

If you're using checkboxes from the Control Toolbox Toolbar, you can select them
all and then rightclick on the selection and:

Format Control|Properties tab|Check Move and size with cells

And make sure that each checkbox is completely in that cell/row.

If you're using checkboxes from the Forms toolbar, you won't be able to do
this. (I'd replace them with the control toolbox toolbar version.)

Goldenfoot wrote:

I have 8 check boxes in Excel on rows 1:4 and 6:9. I have other macros that
hide and unhide these rows together or separately. When all rows are hidden
and then unhidden, the checkboxes all stack up at the bottom on row 10.

Any property value I am overlooking with respect to the movements?

Thanks,
GoldenFoot


--

Dave Peterson