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?

 

[PHV]

When I code it
Which code ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SkipVought]

I do not believe that ScrollArea is a property that gets saved.

Run the macro that sets the ScrollArea in the Workbook_Open event.

Skip,
[sub]
Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty![/sub]

 

[philfer]

After I do ActiveSheet.Copy

I do Activesheet.ScrollArea = "A1:E45"

it works until I close it down and re-open it