View Single Post
  #4  
Old April 9th, 2010, 05:35 PM posted to microsoft.public.excel.newusers,microsoft.public.excel.programming
Blue Max
external usenet poster
 
Posts: 301
Default Controls collapsed with outline

Thanks, Dave. I had already used the "Format Control" option to mark the
boxes to 'Move' with cells, but still seem to have the problem. Thanks,
however, for the suggestion, I will double check just to make sure.

Thanks,

Richard

*********************
"ozgrid.com" wrote in message
...
Right click on the Checkbox and choose "Format Control" and then the
"Properties" tab for 3 options.


--
Regards
Dave Hawley
www.ozgrid.com
"Blue Max" wrote in message
...
We have a problem with a column of checkbox controls linked to cells.
When a group of rows is collapsed using the outline feature, the controls
in the collapsed portion of the column are eventually all stacked on top
of each other.

Then, when the outline is re-expanded, the checkbox controls are no
longer on top of the cell they were linked to in the column before
collapsing the outline. Instead, the whole group of controls is stacked
over a single cell at the bottom of the collapsed section.

How do we link the controls to the cells so that they will reappear over
the proper cells when the outline is expanded?