simple question

[shlomop]

how can i make that you should not be able to scroll down a sheet

 

[Dave Peterson]

You can make it so that users can't scroll off the area that you set. But it
requires a small macro:

Option Explicit
Sub auto_open()
With Worksheets("sheet1")
.ScrollArea = "a1:g55"
End With
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[patele]

Another way:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Me.ScrollArea = "A1:J20"
End Sub

E

 

[Dave Peterson]

I'm not sure I'd use the _selectionchange event. To toggle that setting to the
same range address each time you change selection seems a little overkill to me.

 

[patele]

Maybe I'm missing something, where's the overkill?

 

[Dave Peterson]

Each time the user changes the selection, this code will run:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Me.ScrollArea = "A1:J20"
End Sub

After it's been set the first time, it's not changing anything.

But the code still runs each and everytime the user changes the selection.