I'm embarrassed I can't figure this out but someone sent me a workbook with protected sheets (workbook is unprotected) that does the follow.
If any cell is row 1 is selected and the user hits the UP arrow, the worksheet automatically jumps to row 419. If the user hits down on row 419, we go back to row 1.
If any cell in Column A is selected and the user hits the LEFT arrow, the worksheet automatically jumps to column W. If user hits RIGHT arrow in Column W, we go back to column A.
In essence, worksheet is turned into a circle.
How can I turn this annoying feature off? I have the password and it goes away when the sheet is unprotected so I figure it has to do with cell locking but haven't been able to figure out the solution. I do need the final version protected so the answer can't be as simple as turning it off. Thanks.
-Actuary.
If any cell is row 1 is selected and the user hits the UP arrow, the worksheet automatically jumps to row 419. If the user hits down on row 419, we go back to row 1.
If any cell in Column A is selected and the user hits the LEFT arrow, the worksheet automatically jumps to column W. If user hits RIGHT arrow in Column W, we go back to column A.
In essence, worksheet is turned into a circle.
How can I turn this annoying feature off? I have the password and it goes away when the sheet is unprotected so I figure it has to do with cell locking but haven't been able to figure out the solution. I do need the final version protected so the answer can't be as simple as turning it off. Thanks.
-Actuary.