Thread
:
How do I name an autoshape so that I can refer to it in a macro?
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
How do I name an autoshape so that I can refer to it in a macro?
One way. Select the shape and look in the NAME box to the left of the
formula box. Change the name there.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Stacy" wrote in message
...
I'm trying to create a macro that changes the color of different
autoshapes
depending on the values of certain cells. Each autoshape would change,
depending on the value of a different cell. So, I need to refer to each
autoshape separately. When I recorded the macro, it refers to "Rectangle
220" for every rectangle, so when I run it, it only changes the first
rectangle to the correct color.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett