Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide/Unhide worksheets upon entries in a range of the main worksheet
I have a workbook with 6 worksheets of the same format (name it target
1-6). In my main worksheet (name it assessment) I have an overview of related values. In cells A5:A10 of the latter, I give a catch-word for each target, which then will be displayed in the respecitive target worksheet. In cells F5:F10 I give the weight of each target (e.g. 10, 20, or blank, if no weight). I wish to have a code that displays the main worksheet and hides all target worksheets (since the values in the weight column are blank) as long as no values have been entered. Entering a value in the weight-column must display the corresponding worksheet. Deleting or setting the value to 0 must hide the corresponding worksheet again (conditionally/dynamically on changing values). Any experience on this? Many thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
take all data from several worksheets to one main worksheet? | Excel Discussion (Misc queries) | |||
Viewing other worksheets in a main worksheet | Excel Discussion (Misc queries) | |||
How do I hide and unhide worksheets in Excel 2007? | Excel Discussion (Misc queries) | |||
how do i format from the main worksheet to the other worksheets s. | New Users to Excel | |||
Can I hide a worksheet and set a passwd to unhide it? | Excel Worksheet Functions |