Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 50
Default Problem using group function with hidden rows

I have a worksheet containing 10 sets of rows containing different versions
of data. Within each of these 10 sets, there are "grouped" rows that can be
hidden/unhidden when clicking the appropriate group button (Level 1 unhides
the rows, Level 2 hides them.) In addition, this worksheet contains macros
whereby the user can select which of the 10 data versions they want to view.


The issue I am having is when the user tries to intermix these view options.
For example, let's say the user has chosen to view data sets 1, 3, and 5
(which hides all of the rows associated with the other versions). If they
secondarily select the "Level 1" button to unhide the grouped rows for the
chosen data sets, it also unhides all of the rows associated with the data
versions the user didn't want to see. Does Excel view grouping/ungrouping
rows the exact same way as hiding/unhiding them? In other words, when I
click the "Level 1" button, does Excel simply view that as an "unhide all
rows" command? What I obviously want it to do is unhide the "grouped rows"
from within the currently visible rows. Is there any way to do this??
Reply
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
Problem with hidden rows automatically unhiding scarlet Excel Discussion (Misc queries) 2 December 7th 09 02:42 PM
opening a group but keep hidden rows hidden MWL Excel Discussion (Misc queries) 0 February 17th 09 04:16 PM
very odd problem - rows have disappeared. Not hidden, height is no PBcorn Excel Discussion (Misc queries) 2 October 13th 08 02:53 PM
Problem printing hidden rows [email protected] Excel Programming 0 June 2nd 08 08:45 PM
Ignore Hidden Rows in Sum Function? Jugglertwo Excel Discussion (Misc queries) 3 February 10th 05 02:00 AM


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

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

About Us

"It's about Microsoft Excel"