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

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