View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tomic tomic is offline
external usenet poster
 
Posts: 12
Default Hide Autoshape based on Cell Value

I've tried several things, based on some other posts here, but haven't been
successful in getting this to work.

I would like to hide an autoshape, named "Change" based on the value of a
cell "E5" in a worksheet named "Flow Rates". Basically, if E5 = 0, I don't
want the user to see this autoshape.

Any help would be appreciated. I have a feeling this is fairly simple, but
as my VB knowledge is fairly limited, I haven't been able to figure it out.

Thanks.