How to create a view option (or hide/unhide preselected cells) (Repost from Misc)

[Turquoise_dax]

I have the following problem: I need to set a worksheet so the user can choose to view/print it with or without the cells containing exhaustive explanations. (Those cells are NOT in a single bundle...)

Is there a way, (say, with a button or another macro), that I could set this worksheet to hide or unhide preselected rows so the user can switch from one view to another in a single simple operation?

(Any suggestion is welcome: I need all available options.)

THANKS!

For those who wants to know the purpose: it is a compliance matrix (checklist-like) with design requirements. The cells that need to be set are the ones containing secondary information regarding each of the requirements. (The "simple" view should allow to shorten the list considerably, without loosing the information.)

[Jim Jackson]

You could try the "Autofilter" approach.

When the button for "Incomplete" could trigger the following code:

Sheets("Sheetname").Select
Activesheet.Columns("D").select ' Assuming Column D holds the terms
"Complete" and "Incomplete"

Selection.AutoFilter Field:=1, Criteria1:="=Incomplete"

Jim

"Turquoise_dax" wrote:

>
> I have the following problem: I need to set a worksheet so the user can
> choose to view/print it with or without the cells containing exhaustive
> explanations. (Those cells are NOT in a single bundle...)
>
> Is there a way, (say, with a button or another macro), that I could set
> this worksheet to hide or unhide preselected rows so the user can switch
> from one view to another in a single simple operation?
>
> (Any suggestion is welcome: I need all available options.)
>
> THANKS!
>
> For those who wants to know the purpose: it is a compliance matrix
> (checklist-like) with design requirements. The cells that need to be
> set are the ones containing secondary information regarding each of the
> requirements. (The "simple" view should allow to shorten the list
> considerably, without loosing the information.)
>
>
> --
> Turquoise_dax
> ------------------------------------------------------------------------
> Turquoise_dax's Profile: http://www.excelforum.com/member.php...o&userid=35185
> View this thread: http://www.excelforum.com/showthread...hreadid=552401
>
>

[Turquoise_dax]

I tried it, (adjusting column and criteria, of course!), and when I click the button, it hides all rows (2-12) while only the 8 and 11 contained the criteria.

On the other hand, I am a newbie at trying to programm buttons, so maybe I do something wrong right from the start...

(I used the tool to create the button, I assigned a macro, and I went in visual basic, simply cutting/pasting your code, getting rid of the comments and adjusting column letter and criteria.)

[topper09er]

I am not very good at macros or more advanced things in excel, but what
I would do is just make a checkbox that asks if the user wants the long
explanations on/off and link it to say A1. Then in the cells with the
long explanations put the code: =if(A1=true,"long
exanations...","shorter explanations..."), or go into conditional
formatting and type under formula =A1=true then change the font color
to white so it does not appear.

just some ideas of what i might try

Turquoise_dax wrote:
> I have the following problem: I need to set a worksheet so the user can
> choose to view/print it with or without the cells containing exhaustive
> explanations. (Those cells are NOT in a single bundle...)
>
> Is there a way, (say, with a button or another macro), that I could set
> this worksheet to hide or unhide preselected rows so the user can switch
> from one view to another in a single simple operation?
>
> (Any suggestion is welcome: I need all available options.)
>
> THANKS!
>
> For those who wants to know the purpose: it is a compliance matrix
> (checklist-like) with design requirements. The cells that need to be
> set are the ones containing secondary information regarding each of the
> requirements. (The "simple" view should allow to shorten the list
> considerably, without loosing the information.)
>
>
> --
> Turquoise_dax
> ------------------------------------------------------------------------
> Turquoise_dax's Profile: http://www.excelforum.com/member.php...o&userid=35185
> View this thread: http://www.excelforum.com/showthread...hreadid=552401

[Jim Jackson]

I should have asked if your other columns were set for Autofilter. In the
example I gave, if columns A through D are set for Autofilter then use
Field:=4 and it should work.

Jim

"Jim Jackson" wrote:

> You could try the "Autofilter" approach.
>
> When the button for "Incomplete" could trigger the following code:
>
> Sheets("Sheetname").Select
> Activesheet.Columns("D").select ' Assuming Column D holds the terms
> "Complete" and "Incomplete"
>
> Selection.AutoFilter Field:=1, Criteria1:="=Incomplete"
>
> Jim
>
> "Turquoise_dax" wrote:
>
> >
> > I have the following problem: I need to set a worksheet so the user can
> > choose to view/print it with or without the cells containing exhaustive
> > explanations. (Those cells are NOT in a single bundle...)
> >
> > Is there a way, (say, with a button or another macro), that I could set
> > this worksheet to hide or unhide preselected rows so the user can switch
> > from one view to another in a single simple operation?
> >
> > (Any suggestion is welcome: I need all available options.)
> >
> > THANKS!
> >
> > For those who wants to know the purpose: it is a compliance matrix
> > (checklist-like) with design requirements. The cells that need to be
> > set are the ones containing secondary information regarding each of the
> > requirements. (The "simple" view should allow to shorten the list
> > considerably, without loosing the information.)
> >
> >
> > --
> > Turquoise_dax
> > ------------------------------------------------------------------------
> > Turquoise_dax's Profile: http://www.excelforum.com/member.php...o&userid=35185
> > View this thread: http://www.excelforum.com/showthread...hreadid=552401
> >
> >