LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.newusers,microsoft.public.excel.programming
external usenet poster
 
Posts: 113
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 Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Controls collapsed with outline Blue Max New Users to Excel 3 April 9th 10 05:35 PM
How to retrieve data from groups & outline when they r collapsed g Vinod[_2_] Excel Discussion (Misc queries) 2 November 11th 08 10:25 PM
How to keep sheet modules collapsed? Gregg[_4_] Excel Programming 6 August 7th 07 05:51 AM
My pie chart has collapsed, what do I do? Duke Charts and Charting in Excel 1 January 24th 06 10:03 AM
How can I allow an outline to be collapsed on a protected sheet? LynnAnnO Excel Worksheet Functions 0 June 8th 05 05:39 PM


All times are GMT +1. The time now is 03:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"