Must be easy?!

[Ian Mac]

I have several buttons in a workbook.

These button are from the Forms toolbar.

Once I've assigned a name to them how can I change that name later??

The reason I ask is I've Copied one sheet of data to ALL the others and now of course ALL the button have the same name. The problem being they run a macro with Application.Caller in to goto certain sheets, NOW they don't of course.

Kind regards

[robfo0]

Select the button, then just type your new name in the name box (upper left, to the left of the formula bar) and press enter, and that should do it. I hope your version of excel has the name bar, I'm using 2000 and it does.

[Ian Mac]

If only 'twas that easy. I tried that.
I typed the new name in, Pressed enter, The new name remained in the name box. selected a cell, selected the button and low and behold, back to the old name????????

by the way, I'm using XL97 SR-2.

_________________
Share the wealth!!
Ian Mac

[ This Message was edited by: Ian Mac on 2002-04-05 01:41 ]

[robfo0]

Maybe try deleting the unused old names from the list first? Insert->Name->Define then delete the ones you dont want, the try the naming again. hopefully that works

[Ian Mac]

Unfortunatly the Button Names don't appear in the Name>Define dialogue box. I'd like to know where they bleedin go thought

Thanks for still trying.

[robfo0]

doh must be an excel97 unique thing, i tried doing the same thing and it works fine in excel 2000...only other thing I can think of is maybe it is still linked to the other workbook and thats why it wont let you change it? Try Edit->Links.

[BarrettM]

I use excel 97.

Try this.

Mouse over the button, right click and then edit text, you can also reassign a macro to the button.

[BarrettM]

I use excel 97.

Try this.

Mouse over the button, right click and then edit text, you can also reassign a macro to the button.

[Ian Mac]

On 2002-04-05 02:50, BarrettM wrote:
I use excel 97.

Try this.

Mouse over the button, right click and then edit text, you can also reassign a macro to the button.

Doing the above will ONLY change the text on the button itself, the Application.Caller won't be looking at that.
Also the macro I'm dynamically changes with the use of the Application.Caller.

My problem is I assigned names to all the buttons and used

Sub SelectTotals()

Sheets("TeamTotals" & Application.Caller).Select
Range("h4").Value = ""

End Sub

to select different sheets depending on what the button is called.

[anand]

Hi,

You can change the name of the button using a simple macro.

Just select the button and try running the following macro. This will first display the current name and then I am changing the name to "NewName" and then the object.name will become NewName. So you can have a generic routine which can ask for the name and then set that name using object.name = .

The example routine:
--------------------
Sub ChangeName()
Dim Obj As Object
Set Obj = Selection
MsgBox Obj.Name
Obj.Name = "NewName"
MsgBox Obj.Name
End Sub

I hope it helps. Is there any direct way??

Anand