Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide objects based on value in cell
I have used autoshapes to manually create an organization chart in Excel (as
opposed to using Insert = Diagram = Organization Chart). The text in each box of the flow chart is linked to cells in a separate worksheet. Is there a way to hide an object if the cell it is linked to is blank? I'm using Excel (Office 2002, SP-2). Thanks! Julia Chromicz |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide objects based on value in cell
For each shape you have that needs to be switched on/off, you could put a
line like the one below in your Worksheet_Change event proceducould put in a Worksheet_Change event procedure such as this: Sheets("Sheet1").Shapes("MyShape 1").Visible = (Range("LinkedCell1").Value < "") This should work even if the cell value is the result of a formula. "Julia Chromicz" wrote: I have used autoshapes to manually create an organization chart in Excel (as opposed to using Insert = Diagram = Organization Chart). The text in each box of the flow chart is linked to cells in a separate worksheet. Is there a way to hide an object if the cell it is linked to is blank? I'm using Excel (Office 2002, SP-2). Thanks! Julia Chromicz |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hide row based on cell value | Excel Worksheet Functions | |||
Hide row based on cell value | Excel Worksheet Functions | |||
Is there a way to HIDE a row based on a value of a cell ? | Excel Discussion (Misc queries) | |||
How do you hide a row based upon cell criteria? | Excel Programming | |||
Hide Row Based on cell value | Excel Programming |