Limiting the size of a worksheet
 

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

Limiting the size of a worksheet
 

Hi Ulf
one way: simply hide these rows/columns

--
Regards
Frank Kabel
Frankfurt, Germany

Ulf Liljensten wrote:
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

Limiting the size of a worksheet
 

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


On Fri, 05 Mar 2004 15:00:28 GMT, Ulf Liljensten
wrote:

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