When the freeform tool is used to draw a shape the "Name Box" in Excel displays a default name. e.g. Freeform 6.
Is it possible to change the default name given in the "Name Box". i.e to change "Freeform 6" to "FunnyShape"?
I have tried usign insert>name>define this seems to work but I am unable to access it using a macro.
Appreciate any Help.