Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Autoshape
I have a lot of triangle autoshapes in row 20, that are used as macro
buttons. I want the current button that is being used to change to a differant color. I have each autoshape programmed to change color when selected. What I need is a way for the autoshape to return to its original color when another autoshape is selected. Something to the effect; ActiveSheet.Shapes("Row 20").Select Selection.ShapeRange.Fill.ForeColor.SchemeColor = 13 Selection.ShapeRange.Fill.Visible = msoTrue Selection.ShapeRange.Fill.Solid As always, any help/suggestions is very much appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
autoshape | Excel Discussion (Misc queries) | |||
Autoshape | Excel Discussion (Misc queries) | |||
NAME OF AUTOSHAPE | Excel Discussion (Misc queries) | |||
AUTOSHAPE | Excel Programming | |||
autoshape | Excel Programming |