Give your shapes a meaningful name such as "oval_001", "oval_002" etc.

Link them all to the same macro and in the code use Application.Caller to
find which one was clicked.

Tim


wrote in message
ups.com...
Hi,

I am in dire need of help.
Currently I have created 3 basic shapes, oval, to represent red,
yellow and green respectively. I have also assigned a macro to each
shapes so that when I clicked on it, the colour will change
accordingly. My 3 shapes are in one cell. My problem is that I have at
least 30 rows and each row has 3 columns of these shapes.. Total is 90
oval shapes... numbering from 1 to 90... In order to create successful
macro, I have to create 90 macros (because of the oval shapes
numbering). Is there any shortcut whereby I can create only 3 macros
and assign it accordingly w/o having it linked to other shapes.

Appreciate all help given...