Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
hide / unhide columns
I have approximately 10 columns that I want to hide or un-hide.
I was thinking of having associate text in B1 that may say hide column F If A1 has an x it means hide column F And associated text in B2 that may say un-hide column F If A2 has an x it means un-hide column F Another thought was to use radio buttons The values in A1 and A2 are mutually exclusive. That is, if A1 = x then A2 will not = x. Same for A3 and A4. The information will continue down to additional rows for each column I want to hide or un-hide. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
hide / unhide columns
a more detailed explanation would be helpful but you could use a worksheet
change event with select case. -- Don Guillett SalesAid Software "appeng" wrote in message ... I have approximately 10 columns that I want to hide or un-hide. I was thinking of having associate text in B1 that may say hide column F If A1 has an x it means hide column F And associated text in B2 that may say un-hide column F If A2 has an x it means un-hide column F Another thought was to use radio buttons The values in A1 and A2 are mutually exclusive. That is, if A1 = x then A2 will not = x. Same for A3 and A4. The information will continue down to additional rows for each column I want to hide or un-hide. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How Unhide & Hide Columns with VBA | Excel Discussion (Misc queries) | |||
Hide / Unhide columns for Printing | Excel Discussion (Misc queries) | |||
Auto hide/Unhide columns | Excel Worksheet Functions | |||
Hide/Unhide columns using button on top over relevant columns | Excel Discussion (Misc queries) | |||
Unhide and hide columns | Excel Worksheet Functions |