Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet Automation and Size Limiting | Excel Worksheet Functions | |||
Limiting cell size to 25 characters | Excel Discussion (Misc queries) | |||
uisng two paramaters for conditional formatting / Limiting screen size | Excel Discussion (Misc queries) | |||
Limiting size field MS query returns | Excel Discussion (Misc queries) | |||
Limiting access to a worksheet | Excel Programming |