Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I have several pieces of data on a work sheet which i will create as my template. But not all cells i will use on a work sheet and when i come to print the worksheet out, i would like to hide the rows of information which i will not be using. I was thinking along the lines of using a check box at the top of the page. So when the box is ticked the rows would unhide and show the revelent infomation. I would have several boxs unhiding different rows. These rows would not cross over each other. i.e check box 1 would unhide row 5-10, check box 2 would unhide 15-20, and so on and so on. Is this possible????????? Also if there is any other functions which would do this job, suggestion would be greatfully appreciated!! -- Jonno |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CommandButton used to hide and unhide rows | Excel Discussion (Misc queries) | |||
VB Code to hide and unhide rows | Excel Discussion (Misc queries) | |||
CONDITIONAL HIDE/UNHIDE ROWS | Excel Discussion (Misc queries) | |||
Macro that will unhide then hide rows | Excel Discussion (Misc queries) | |||
Hide Unhide Rows | Excel Discussion (Misc queries) |