Limiting the size of a worksheet

U

Ulf Liljensten

I need to keep the scrollbars but limit the size of a worksheet to keep
the users from scrolling around outside of my application. I would like
to simply remove all rows/columns after a certain row/column number.
Anyone knows the easiest way do do this?

thanks,

Ulf
 
G

Gord Dibben

Ulf

Couple of options.

1. Hide the columns you don't want to be visible.

2. You may want to try setting the Scroll Area.

This setting will not remain after closing the file.
Place a code line in the Workbook open event to set it
each time when you open the workbook

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

Adjust to your sheetname and range.

Gord Dibben Excel MVP
 
Top