limiting sheet size

[stebou]

Is there a way to limit the number of rows and columns available on a spreadsheet? For example in a workboor on one page I only want 26 colums and 2000 rows. On the next sheet I want 10 columns and 50 rows. I don't want to just hed the cells. I've seen this on some older spreadsheets, but can't seem to make it happen. Thanks for your help.

 

[VoG]

You can use code like this, maybe in the Workbook_Open event

With Sheets("Sheet1")
    .ScrollArea = "A1:Z2000"
End With

 

[stebou]

I pasted the code on the code page, saved the workbook, and reopened it, but it didn't make any diffference. What am I doing wrong?

 

[VoG]

In the ThisWorkbook module

Private Sub Workbook_Open()
With Sheets("Sheet1")
    .ScrollArea = "A1:Z2000"
End With
End Sub