Lockink the scrolling of a cursor in a protected sheet.

[Guest]

Hi! Can someone help me please?
I have a large worksheet that's protected and most of the cells are locked
When I scroll thru the sheet with the arrow keys (left arrow key, for example) instead of stopping when it hits left side of the sheet (column a) it jumps all the way to the right of the sheet. The same thing happens when i scroll up with the up arrow key, it moves to the bottom of the sheet instead of stopping when i hit the top (row 1

It's driving me nuts

I want it to stop when you reach the left or top, just like it does when the sheet is unprotected
thanx in advanc
Robert~

 

[Peter Atherton]

Robert

Use the TAB key to go across columns and ENTER to go down
a column

Peter

-----Original Message-----
Hi! Can someone help me please??
I have a large worksheet that's protected and most of the cells are locked.
When I scroll thru the sheet with the arrow keys (left

arrow key, for example) instead of stopping when it hits
left side of the sheet (column a) it jumps all the way to
the right of the sheet. The same thing happens when i
scroll up with the up arrow key, it moves to the bottom of
the sheet instead of stopping when i hit the top (row 1)

It's driving me nuts!

I want it to stop when you reach the left or top, just

like it does when the sheet is unprotected.

 

[Guest]

Thanks, but i would really prefer using the arrow keys, because it's much more convenient and that's what i'm used to..

any suggestions?