Scroll bars

I have forms and want the scrol bars to only move the form to the edge of the sheet instead of ten or mor cell beyond.

Good evening amsanborn

Originally Posted by amsanborn

I have forms and want the scrol bars to only move the form to the edge of the sheet instead of ten or mor cell beyond.

You have two choices here, that aren't quite perfect, but should help out. We'll assume that your form extends from A1:Z100 on Sheet1.

1. Hide all rows from 101 to 65536, and all columns from AA to IV. This will mean that no-one can move beyond your prescribed range.
2. Alternatively, limit the ScrollArea : the only way to do this is via the VBE or using a macro. Use this macro in your ThisWorkbook module to perform the function every time the workbook is opened (the scrollarea once set does not save with the workbook) :

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

HTH

DominicB