Hi all,

I am having some trouble getting macros to assign correctly I have tried to search the forum for similar problems but I get an error message.

I have two workbooks; template.xls and working.xls which contain macro's assigned to command button clicks. When I copy the sheet located in the template.xls into the working.xls the macro assignment is still set to "template.xls'!button_click#" and I have to go through each command button and manually reassign it to "working.xls'!button_click#"

Is there anyway I can get excel to do this for me by somehow assigning the button to the button_click macro in the current workbook?

Thanks in advance.

Chris.