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

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

Bob,

Thanks very much for this. Having tried out your advice I see that the 1 in
brackets indicates the order in which the shapes were placed on the
worksheet? If I ran the code to change the shape names, would the name
changes be saved with the workbook or would I have to reassign each on Open
or something similar?

Thanks again

John
"Bob Phillips" wrote in message
...
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

As long as you saved the workbook after changing the names, the names would
be retained.

--
Regards,
Tom Ogilvy

"John" wrote in message
...
Bob,

Thanks very much for this. Having tried out your advice I see that the 1
in
brackets indicates the order in which the shapes were placed on the
worksheet? If I ran the code to change the shape names, would the name
changes be saved with the workbook or would I have to reassign each on
Open
or something similar?

Thanks again

John
"Bob Phillips" wrote in message
...
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

Damn that's quick!

Thanks Tom
"Tom Ogilvy" wrote in message
...
As long as you saved the workbook after changing the names, the names
would
be retained.

--
Regards,
Tom Ogilvy

"John" wrote in message
...
Bob,

Thanks very much for this. Having tried out your advice I see that the 1
in
brackets indicates the order in which the shapes were placed on the
worksheet? If I ran the code to change the shape names, would the name
changes be saved with the workbook or would I have to reassign each on
Open
or something similar?

Thanks again

John
"Bob Phillips" wrote in message
...
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