Solved: set scroll area in copied book

[philfer]

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?

[Carl A]

Here is a KB entry for deleting and adding macros. You should be able to adjust it for a new worksheet.

http://vbaexpress.com/kb/getarticle.php?kb_id=250

HTH