Jehannum_2000
New Member
- Joined
- Sep 14, 2024
- Messages
- 16
- Office Version
- Prefer Not To Say
- Platform
- Windows
The first 7 rows of the spreadsheet are fixed in place (with Freeze Pane, if I remember rightly).
If the user is on row 8 and presses the up arrow key where there is a locked, unselectable cell above, Excel scrolls to row 65 (the last row that allows data entry).
This is annoying for the user. There is not usually any data this far down, so they just see blank rows.
Instead, I want the active cell simply to stay at row 8, i.e. for there to be no scrolling down to row 65.
I don't want the user to have to use Scroll Lock (which may or may not be on their keyboard). I want Excel or VBA to enforce the above behaviour.
I'd be grateful for a solution.
If the user is on row 8 and presses the up arrow key where there is a locked, unselectable cell above, Excel scrolls to row 65 (the last row that allows data entry).
This is annoying for the user. There is not usually any data this far down, so they just see blank rows.
Instead, I want the active cell simply to stay at row 8, i.e. for there to be no scrolling down to row 65.
I don't want the user to have to use Scroll Lock (which may or may not be on their keyboard). I want Excel or VBA to enforce the above behaviour.
I'd be grateful for a solution.