| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Showing and hiding columns
use the change event and check if the Target is cell C1. If so, then take
the appropriate action. -- Regards, Tom Ogilvy "BatMan" wrote in message ... I need help hiding and showing columns based on a cell value. When my workbook opens column H and I are hidden. Cell C1 is a cell that I have validation. When the user selects "THIS" in cell C1 I would like column H to appear. If the user selects "THAT" in cell C1 then I want column I to appear and column H to be hidden. Can this be done? T.I.A. Ed |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Showing and hiding columns
I need help hiding and showing columns based on a cell value. When my
workbook opens column H and I are hidden. Cell C1 is a cell that I have validation. When the user selects "THIS" in cell C1 I would like column H to appear. If the user selects "THAT" in cell C1 then I want column I to appear and column H to be hidden. Can this be done? T.I.A. Ed |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro showing and hiding detail | Excel Discussion (Misc queries) | |||
| Hiding and Showing Sheets using Macro | Excel Discussion (Misc queries) | |||
| Showing and hiding series in charts | Excel Discussion (Misc queries) | |||
| hiding and showing graphs | Excel Worksheet Functions | |||
| hiding showing columns using checkboxes | Excel Programming | |||
Linear Mode
