I use Activesheet.Copy to create a copy of a worksheet.

However I want to set the scroll area in that new worksheet. When I code it after the ActiveSheet.Copy it works ok until I close the workbook and open it up again when the scroll area has not been saved.

Is there any way to put code into another workbook from code in the original workbook?