Hide objects based on value in cell

[Guest]

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

 

[Guest]

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 procedure:could 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.