Dear NG:

I'm somewhat new to spreadsheets and VB so please bear with me.

I wanted to restrict the scroll area of sheet01 (since it only contains a
graph) to A1:Q26.

If I open the Visual Basic Editor and enter A1:Q26 in ScrollArea of the
Properties Window,
the scroll area is restricted as expected. However, saving, closing and
reopening Excel erases
the entry in VB's ScrollArea Properties Window.

I've entered Sheet01.ScrollArea = "A1:Q26" into the sub Private Sub
Worksheet_SelectionChange.
which seems to work OK.

Is this the preferred or proper way to go about what I'm trying to
accomplish.

Thanks for any insights.

-Kevin