View Single Post
  #2  
Old April 7th, 2010, 03:51 AM posted to microsoft.public.excel.newusers,microsoft.public.excel.programming
ozgrid.com
external usenet poster
 
Posts: 328
Default Controls collapsed with outline

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?