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