Command Button Problem

[funkmonsteruk]

I've got an excel spreedsheet template which has several command buttons on it, i have re-named all of the command buttons.

When i insert the sheet from the template it re-names all of the command buttons back to their original titles (commandbutton1, commandbutton2 etc) This is anoying because i have to individually rename all the command buttons to get the assigned macros to work again.

Does anybody know a way around this?

 

[SgtPepps]

Do your command buttons need to be renamed? cant you just leave them as defult, then when you create a new document from the template there are no changes made.

or

write this code in the "This Workbook" object and modify as necessary. It will run everytime workbook is opened renaming any buttons.

Sub Workbook_Open()
commandbutton1.name = "your new name 1"
commandbutton2.name = "your new name 2"
End Sub

 

[funkmonsteruk]

Cheers sgtpeps...works like a dream