Navigation problems in protected Worksheet

[JayBee01]

Greetings Experts!

Could someone please advised how to do the following in a Protected Worksheet:

1. Stop Excel navigating to the final row of the worksheet if the user presses the up arrow in row1.

2. Allow pressing the Home key on the keyboard to take the user to Colum A of the current row.

The password for this example Workbook is just 'password'. Additional info that might be useful is in the Worksheet 'README_NOTES'.

Thank you in anticipation.

[Eastw00d]

Hi,
if the user presses the up arrow the cursor goes to the last cell of the used range, i.e. L38224, because column G is copied down to that row.
To prevent the user to go to A1, block A1:L2 in the cell properties, just like you did in column G, and freeze the rows and columns above row 3.
And after this you can protect your sheet again.

Cheers
Erwin