Macro to delete macro button issues

[Dibbley247]

Hi Guys

I have a situation where I have a code which copies a sheet and renames it a cell value.
But these sheets which have been copied over also have the macro button on which I want deleted.

So I recorded a macro in 2003 excel then had issues when using it in the 1997 excel in work.

The problem I got is: In the newer version, the macro button is called "Button1" but in the older version its called "Button 14"

Is there a way which i can delete this button?

Here is the code below so you can see whats happening:

Please Login or Register  to view this content.

[HaHoBe]

Hi, Dibbley247,

have you tried giving a name to the button other the standard from VBA?

Or you might try acting upon the Version used to decide what number the button has (I assumed 2007 as 12 whereas 97 would be 8):

Please Login or Register  to view this content.

Ciao,
Holger

[Norie]

Try this.

Please Login or Register  to view this content.

[Dibbley247]

Thanks guys.
Just tried the one from Norie and its worked on the older version.

I never thought about renaming the button!!!!
thanks for your help guys!