Modify VBA Code Dynamically when copying and exisiting worksheet to a new one

[EvanLS]

I have an Excel 2016 workbook with one worksheet.
Within are many lines of code which refer to "Sheet1" (i.e. Sheet1.Select)

At the beginning of a new year, a new worksheet is created ("worksheet2") using VBA code.
It's simply a backup to worksheet1 in a new tab.
That seems to be working well.

However, I just noticed that certain aspects of the code within the newly created "worksheet2" do not execute properly.
Upon further inspection, I see that the code in "worksheet2" still refer to "worksheet1" (i.e. Sheet1.Select)

Is there a way to dynamically change the VBA code in the new "worksheet2" to point to "worksheet2" during its creation,
rather than still point to "workshheet1"

I hope I've explained my problem well.
Thanks for any help

[maniacb]

Here is a shot in the dark. If you change the code that says sheet1 to activesheet, then the code will apply to whichever sheet is active. Hard to tell if this will work correctly for you without seeing your workbook, though.

[Norie]

Where is the code located?

Is there only one sheet in the workbook?

[EvanLS]

Great shot it the dark....brilliant!
Works great.
Thank you!

[EvanLS]

maniacb solved my problem, but to answer your questions.

1. The code is located in both Module1, Workbook1 and Workbook2

2. No, there are now 2 workbooks, but each January another will be created.

Thanks for your help.