View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DORI DORI is offline
external usenet poster
 
Posts: 35
Default How to turn on Shapes conditionally?

Hi All,
Here is the scenario: (Excel 2003)
1) I have created 10 different shapes (Free Form 1 to 10)
2) If the value in H10 is equal to "Box" then I want the Free Form 1 appears
at P10:T15 location
3) If the value in H10 is equal to "Table" then I want the Free Form 2
appears at P10:T15 location
4) If the value in H10 is equal to "Ball" then I want the Free Form 3
appears at P10:T15 location and so on.
I want to have only one Free Form at a time.
How can I do this?
Thanks very much in advance for any comments.
DORI