rohaizad77
New Member
- Joined
- Apr 21, 2010
- Messages
- 2
Hi,
I am using excel 2007, I created a shape from Excel (Insert-Shapes). I want this shape to appear and disappear base on some values but as a first step, I cant even get the visible property to work.
I created a button and in the click event, i do this code.
With ActiveSheet.Shapes("UpArrow3")
.Visible = Not .Visible
End With
I got an error that says....
"The item with the specified name wasn't found." - highlighted the 1st line.
Seems like excel cannot find UpArrow3 - so how do I make sure the shape that i add is called UpArrow3 - how to view its properties????
THanks in advance!!!!
I am using excel 2007, I created a shape from Excel (Insert-Shapes). I want this shape to appear and disappear base on some values but as a first step, I cant even get the visible property to work.
I created a button and in the click event, i do this code.
With ActiveSheet.Shapes("UpArrow3")
.Visible = Not .Visible
End With
I got an error that says....
"The item with the specified name wasn't found." - highlighted the 1st line.
Seems like excel cannot find UpArrow3 - so how do I make sure the shape that i add is called UpArrow3 - how to view its properties????
THanks in advance!!!!