Macro assignment when copying worksheets

[Chinny123]

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.

[p24leclerc]

Actually, your codes are probably in one or more modules which are not copied with the sheet.
If your codes are in the sheet you want to copy, it will be copied with it.