PDA

View Full Version : Solved: setting scroll area in copied worksheet



philfer
01-20-2008, 11:26 AM
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?