John,

You can either do it by selecting the shape on the worksheet and changing
the name in the Names box, or with VBA

activesheet.shapes(1).name="Bob"

--

HTH

RP
(remove nothere from the email address if mailing direct)


"John" wrote in message
...
Hi there,

Can anyone tell me how you can name shapes in excel, so that you can then
reference them programatically?

I'd like to include a number of small circles that change from red to
green
on a given condition. At the moment I can only do this using the
Selection
method, which I want to avoid.

Thanks

John