Hi,

I am fairly new to VBA. I have created a worksheet that has a number of macros. I am trying to copy this worksheet in the same workbook. When i copy the tab all new buttons in my worksheet reference the old sheet. This means i have to go to each button and assign them to a new macro name. i.e. Sheet2Hide_series needs to be assigned to sheet3Hide_series.

Would anyone be able to help explain how i can copy worksheets and automatically update the links in my buttons rather than manually assigning all links?

thanks in advance