CommandButtons Change Names

[mezr]

I have some worksheets that I want to be able to (via code) move copies of to another workbook. These worksheets have commandbuttons on them and the related code is in the respective worksheet module so it can go with the sheet.

However, I'm finding that when I move a copy of a sheet to another workbook, the commandbuttons' names change. Such as "cmd_sort_names" changes to "commandbutton1". Consequently the buttons do not execute the code which was formerly associated with them.

Is there a way around this?

 

[Ken Puls]

Hi there,

This might get you off in the right direction. This is code to add command buttons (and further down the thread to add code to them)

http://www.mrexcel.com/board2/viewtopic.php?t=57679&highlight=addcommandbuttons

It works really well, and could no doubt be incorporated into your macro.

HTH,

 

[mezr]

Thanks Kpuls,

That looks very interesting - and promissing too. I'll work with it and see if it'll solve my problem.

Thanks again!