Stopping the tab down button from taking you to the top of the page if you are last row on protected sheet?

[tonywatsonhelp]

Hi Everyone.

Bit stuck on this.

I have a sheet and F215:M315 are the last range of data i have in the sheet.
the sheet is page protectected so if you press enter or arrow down when you are in the last row it takes you back to the top.
Very frustrating!!!

What I'd like is a macro that if you are in the last row it stop you going back up to the top and leaves you in the same cell.

The big problem is some of The rows are Hidden depending on whats happening so I don't know which row is going to be the last row.

Any ideas how i can do this?

Thanks

Tony

 

[tonywatsonhelp]

Any ideas on this would be very helpful