scrollbar size

[matty ratafairy]

Hello, I have tried to limit my worksheet area to the used rows but my
vertical scrollbar button (the bit which you move) now occupies almost all
the slideable space so I have no control when trying to scroll up or down.
I tried changing the worksheet scrollabel area, deleting rows (which just
keep coming back), changing row height etc.
I just want the scrollbar button to be a reasonable size so that I can move
it up and down with "finesse"

Please, Help me Obi Wan, you're my only hope.

 

[Niek Otten]

Look here:

http://www.contextures.com/xlfaqApp.html#unused

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hello, I have tried to limit my worksheet area to the used rows but my
| vertical scrollbar button (the bit which you move) now occupies almost all
| the slideable space so I have no control when trying to scroll up or down.
| I tried changing the worksheet scrollabel area, deleting rows (which just
| keep coming back), changing row height etc.
| I just want the scrollbar button to be a reasonable size so that I can move
| it up and down with "finesse"
|
| Please, Help me Obi Wan, you're my only hope.

 

[Gord Dibben]

If Debra's site does not give you what you want..........and I am sure it
will...........you could actually set the scrollarea by code so's user's cannot
scroll out of that area.

Since the scrollarea method does not stick between sessions you will have to
reset it each time you open the workbook.

You may wish to place the code into a WorkBook_Open Sub in ThisWorkbook module
and specify which worksheet if only one sheet required.

Adjust the sheetname and range to suit.

Private Sub WorkBook_Open()
Sheets("YourSheet").ScrollArea = "A1:M67"
End Sub

Or also in the Thisworkbook module to limit scrollarea on all sheets.

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
With ActiveSheet
.ScrollArea = "A1:M67"
End With
End Sub


Gord Dibben MS Excel MVP