philfer
01-10-2008, 12:23 PM
I am using ActiveSheet.Copy to create a copy of a worksheet.
However, when I do ScrollArea = "A1:N100" in the new sheet it works until I close it and open it again when the scroll area is removed.
Is there a way from one Workbook to set the ScrollArea in a copied sheet that would save and apply when re-opened.
I am using SaveAs to save it
However, when I do ScrollArea = "A1:N100" in the new sheet it works until I close it and open it again when the scroll area is removed.
Is there a way from one Workbook to set the ScrollArea in a copied sheet that would save and apply when re-opened.
I am using SaveAs to save it