A macro should do this for you!

Click on Tools|Macro|Record new macro, call your macro something descriptive
such as simpleview. Now hide all the rows which you do not want to display.
when done, click on End recording. Create another macro, call it say
completeview, select the range containing the hidden rows, click on
Format|Row and select unhide, then click on end recording. Create two
buttons, one for the simple view, and one for the complete view, and tie the
macros to these buttons.

"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=552339