Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Column Width
I would like to hide/unhide columns using the column width (equal to "0"). I
would like to do this as a result of the contents of a cell. For instance, if user answers "Yes" to a question, then hide column D. Can this be done? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Column Width
You give no detail but this can be done with a worksheet_change event in the
sheet module -- Don Guillett Microsoft MVP Excel SalesAid Software "Nick" wrote in message ... I would like to hide/unhide columns using the column width (equal to "0"). I would like to do this as a result of the contents of a cell. For instance, if user answers "Yes" to a question, then hide column D. Can this be done? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Column Width
For detail.
A1 has a drop down for "Yes" or "No" as choices. I want column C to be hidden if A1="Yes" and unhidden if A1="No". This would be written as an "if" function. =if(A1="Yes", columnwidth C;C=0, columnwidth C;C=10) This doesnt work this way, is there a command that I can use in the formula line to control column width? "Don Guillett" wrote: You give no detail but this can be done with a worksheet_change event in the sheet module -- Don Guillett Microsoft MVP Excel SalesAid Software "Nick" wrote in message ... I would like to hide/unhide columns using the column width (equal to "0"). I would like to do this as a result of the contents of a cell. For instance, if user answers "Yes" to a question, then hide column D. Can this be done? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change Cell Width WITHOUT changing Column width | Excel Discussion (Misc queries) | |||
how do I create multiple column width in the same column in excel | Excel Discussion (Misc queries) | |||
How to make cell width different than the column width it lies in | Excel Discussion (Misc queries) | |||
Varying column width in a column chart | Charts and Charting in Excel | |||
Change the width of a single column in a column chart | Charts and Charting in Excel |