A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Controls collapsed with outline



 
 
Thread Tools Display Modes
  #1  
Old April 7th, 2010, 03:41 AM posted to microsoft.public.excel.newusers,microsoft.public.excel.programming
Blue Max
external usenet poster
 
Posts: 301
Default Controls collapsed with outline

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?

  #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?


  #3  
Old April 7th, 2010, 02:04 PM posted to microsoft.public.excel.newusers,microsoft.public.excel.programming
Dave Peterson
external usenet poster
 
Posts: 19,791
Default Controls collapsed with outline

If you used checkboxes from the Control toolbox toolbar, you can:

rightclick on each
Choose Format Control
Then on the Properties tab, select move and size with cells

If you used checkboxes from the Forms toolbar, you're out of luck. Maybe you
could replace them with checkboxes from the control toolbox toolbar.

(or write a macro that hides the checkboxes, then hides the row????)


Blue Max wrote:

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?


--

Dave Peterson
  #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?



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:24 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.