Could you use the "ScrollArea" property perhaps?

Worksheets(1).ScrollArea = "A1:F10"
Beware this needs to be reset everytime you open the
workbook. Excel doesn't remember your settings from the last time
so you could put it in an "Auto_Open" sub.

Alf