View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ken Johnson
 
Posts: n/a
Default change autoshape by condition from a cell value

Hi emil,
I copied your code, pasted it into a spare sheet's code module, added a
triangle and named it "AutoShape 48". Then, after changing H19 to -1
the triangle disappeared and reappeared when I made H19 =0.

So I don't know what you're doing wrong.

Ken Johnson