Hey guys,

I have some VBA code in a worksheet that I want to copy into a bunch
of other workbooks.

When I copy the sheet, the macro still refers to the old workbook
where the original sheet is located.

Is there any way the VBA code can be copied along with a worksheet?

Thanks in advance!