Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a validation box with yes/no options in it in cell H7.
When "no" is selected I would like to hide columns M and R only. When yes is selected I would like these columns to be displayed. In the same worksheet I have a validation in cell H6 but would like columns P:S hidden if "Total $" is selected from the validation list, columns K:N hidden if "$/eq T" is selected and columns K:S visible if "Total $ & $/eq T" is selected. I need the first validation to work in conjunction with the second so that for example, if total $ is selected and H7 has "yes" selected, only columns K:N are visible. I am working with Excel 2003 and my knowledge of VBA is extremely basic, extending only to pasting code into a module. I am very grateful for any help you can give me on this one. Thanks!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hide / Unhide columns and rows | Excel Discussion (Misc queries) | |||
Hide/Unhide columns using button on top over relevant columns | Excel Discussion (Misc queries) | |||
Unhide and hide columns | Excel Worksheet Functions | |||
How do I hide and unhide the same columns without reselecting | Excel Worksheet Functions | |||
How to hide and unhide Rows & Columns | Excel Worksheet Functions |