View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Julia Chromicz Julia Chromicz is offline
external usenet poster
 
Posts: 3
Default 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