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
|