Scroll then freeze

Hi Neufy16,

Welcome to the forum.

Is it not the windows freeze option that you are looking for ?

Regards,
DILIPandey

<click on below 'star' if this helps>

Okay.. so you want only row 10 to be freezed (like a heading) as soon as users reaches row 10 ?

Regards,
DILIPandey

<click on below 'star' if this helps>

Hi Neufy16,

Scroll and freeze are different features though I have provided codes for both

See attached workbook as sample :-Freeze & scroll lock.xlsm

Open the attached workbook and scroll down using arrow keys. The moment you'll try to pass row 10, it will freeze.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If ActiveCell.Row = 11 Then
Rows("11:11").Select
ActiveWindow.FreezePanes = True
End If
End Sub

For Scroll lock, you can use below code in any standard module. See the instructions given in the code itself and play around

Sub scrollock()

' To lock scoll area for row # 10
Worksheets("sheet1").ScrollArea = "10:10"

' To lock scoll area from row 1 to row  10
Worksheets("sheet1").ScrollArea = "1:10"

'To unlock any scroll area :-
Worksheets("sheet1").ScrollArea = ""

End Sub

Regards,
DILIPandey

<click on below 'star' if this helps>

where do I put this code? I have no idea what this means... how do I apply?

Also that workbook just freezes rows 1 through 10,

As the user scrolls down, rows 1 through 9 need to scroll off the screen and as we scroll past row 10, it freezes on the top.

Okay..

Have you enabled contents (macros) ?
Did you tried moving using your keyboard's down arrow from Row 1 to downwards ?

For the scroll code, Press Alt + F11, Press Alt + I + M and paste that code there... now press Alt + F8 and choose the macro name from there and run.
You also do editing on this code as per my comments

Regards,
DILIPandey

<click on below 'star' if this helps>

Okay..

Row 10 should be freezed and row 1 to 9 should be scrolled up and then row 11 onwards should be scrolled up.... sorry not possible
Because you need row 10 to act as a floating row when you move down and up and I don't think it is achievable

There are two methods, choose which fits your best :-
Scroll lock:- it will lock any range / area like a1:z10 range but then it is locked and will be visible always and you would not be able to move up / down / right / left leaving this range
Freeze panes:- If you apply freeze panes by selecting row 11, freeze pane will be applied on row 10 and then row 1 to row 10 would always be on top ... everytime

choice is yours

Regards,
DILIPandey

<click on below 'star' if this helps>