Re-naming a shape NOT using VBA ?

[keldsor]

When you add a shape to a sheet it's named automaticly - right ?

If you then SELECT the shape - the automatic given name is shown in a combobos in the upper left corner and you can select the text (the name) ... but how can you CHANGE the name ?

You CAN change the selected text (the name) and press ENTER - but it has NO EFFECT on the name of the shape !

How can I re-name a shape NOT using VBA ?

 

[jasonb75]

It can be done by selecting the shape, then changing the name in the 'Name Box' (that's the box above A1 that usually shows the address of the selected cell).

Edit:- reading your post again, it looks like the 'combobox' that you referred to in your post might actually be the 'Name Box' that I've suggested. Changing the name in there works for me, if it is not working for you then there is something amiss that may require further investigation. Could you be more specific as to the type of shape used as it may be specific to certain object types.
If the shape is something like a checkbox, are you using a form control or an activex control?

 

[keldsor]

?????
Read my posting - that's exacly what I try to do - but it doesn't work - yeah, I can change the text in that box, but it has NO EFFECT on the name of the shape !

 

[jasonb75]

Read my posting - that's exacly what I try to do - but it doesn't work - yeah

Read my edit, it works for me!

 

[keldsor]

I just inserts a rectangle, selects it and try to change it's name ... but can't do it as described !

 

[jasonb75]

That is exactly what I have done.

Insert > Shapes > choose and draw shape.
Click 'Name Box', change name, press Enter.

When I click away from the shape, then click back to it, the new name shows in the box. If I click away, then type the name into the box again the shape is selected.

 

[keldsor]

That's exactly what I do too !

You HAVE to have the 'Select objects' checked first though ...

WHAT do I mis here ?

 

[keldsor]

I think I have it now !

The new name must NOT be something that can be interpreted as a cell - I just tried P1 , PP1 and it wont work but 'PersonID 1' works nicely !

THX !

 

[Snakehips]

Posts crossed. Mine now irrelevant so removed.

 

[jasonb75]

The new name must NOT be something that can be interpreted as a cell

Yeah, the identity must be unique, you wouldn't be able to use a cell reference or a name that is used for a named range.

There may also be some special characters that are not valid, but the common ones which are not permitted in named ranges are allowed for shapes.