copied sheet1 to a new sheet2

Hello
i have a workbook that has one sheet named sheet1 and macro modules that reference to sheet1, i have copied sheet1 to sheet2 to be in the same workbook using the below vba code
the only issue i have faced that sheet2 macro modules still reference to sheet1. is there a way that macro on the new sheet (sheet2) changes to sheet2 instead of still saying sheet1 ?

Please Login or Register  to view this content.