Rick, all works fine! Thank you for your attention and time! Kees

Rick Hansen Wrote:
Kees, here is the procedure to insert your code Workbook_Open().

First goto the VB Editor, now from VBA Project Explore window right
click on "ThisWorkbook", now click on "view code". Now on the left
side
above the edit window click on the drop list and select "Workbook",
now
from the right side drop down click and select the event. In your
case
select "Open". Now VBE will place skeleton structure of
Workbook_Open()
sub into the edit window. Now add the code to this sub ie...

Private Sub Workbook_Open()

Worksheets("Sheet1").ScrollArea = "A1:J20"

End Sub

enjoy, Rick


--
Kees Korver
------------------------------------------------------------------------
Kees Korver's Profile: http://www.excelforum.com/member.php...o&userid=21562
View this thread: http://www.excelforum.com/showthread...hreadid=532165