| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet Show
Hi.
On sheet1 in column A I have 14 tools listed in A6:A20. In column C6:C20 I have TRUE or FALSE values which are managed by tick boxes located over column B. Each tool has a sheet named after it. How can I make it so that if a tool is designated a TRUE, then the sheet will show, and if a FALSE will keep it hidden. The tool names are exactly the same as the sheet names... I've managed this with one sheet but got lost doing more than one. Any help from anyone seriously clever will be appreciated... Thanks in advance. Gordon... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help with a project sheet, need date to show/not show based o | Excel Discussion (Misc queries) | |||
| How to format sheet to show first box whilst tabbing across sheet | Excel Discussion (Misc queries) | |||
| How do i get sheet 2 to show a specific section of sheet 1?Please | Excel Worksheet Functions | |||
| How do I get items from sheet 3 to show up on sheet 1 and 2? | Excel Worksheet Functions | |||
| Excel: have add'l rows entered in sheet 1 always show up in sheet | Excel Worksheet Functions | |||
![Gordon[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
