Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hide Unhide option | Excel Worksheet Functions | |||
Hide/Unhide Option - Need to consider all options! | Excel Discussion (Misc queries) | |||
Switching views - Hide / Unhide preselected cells (Repost) | Excel Discussion (Misc queries) | |||
create option to view worksheet tabs vertically | Setting up and Configuration of Excel | |||
create button that can hide/unhide sheets and hyperlink... | Excel Programming |