Posted to microsoft.public.excel.programming

stacy

external usenet poster

Posts: 27

How do I name an autoshape so that I can refer to it in a macro?

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
AutoShape Macro Help	jack[_2_]	Excel Programming	12	April 13th 08 02:39 PM
autoshape macro	jackrobyn1	Excel Discussion (Misc queries)	1	October 13th 07 11:33 PM
Autoshape Macro	Jim Rech	Excel Programming	3	August 16th 05 10:24 PM
macro in vba to display autoshape	jrd269[_6_]	Excel Programming	0	June 7th 05 08:45 PM
AutoShape name assigned to macro	Larry	Excel Programming	4	October 19th 04 04:15 PM

All times are GMT +1. The time now is 06:06 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us