How did you create this control?

If you used the Form or Drawing control toolbar (or whatever it's now
called) then you won't get the option View Code or Properties.

Do you get options to Assign Macro... and Format Control...?

If you do then you could manually rename the control by selecting it
and replacing whatever appears in the Name box.

If you want to do it with code you'll need something like this.

Set txt = ActiveSheet.Shapes(1)

txt.OLEFormat.Object.Name = "Textbox99"


On Jun 23, 1:02*pm, Mano Nymous
wrote:
Hi,
not quite sure where to post this question but currently I have an excel
spreadsheet. I am trying to get to grips with Office 2007 and I have put a
Test Box control on the page with the intention to rename the control. I am
finding this difficult for a seemingly obvious task.
Any ideas?

Ded