cursor movement

[akcommerce]

Hello friends, I am new to excel. I've prepared an excel sheet from the code given by MUDRAKER in a 2007 post. this VBA code helps me cycle through the unlocked cells. My problem is that my cursor jumps from H4 to L4 instead of going to H5 after protecting the sheet. However, if i remove protection everything runs fine. I think there is some problem with my sheet. I am attaching the excel file.Please help.

[mrice]

Suggest having a look at the Advanced Excel Options - there is a setting which determines which direction the selection should move when the enter key is pressed. You will find these under "File" on the menu bar.

[akcommerce]

Thanks for the reply "mrice". My problem is that the code completely ignores the range H4 to H15 and jumps to L4. The rest of the code is working fine. Please try the sheet I've uploaded earlier. Thanks again.

[akcommerce]

Thanks everyone, I figured it out. The code works fine with arrow keys and not the Tab key. My problem is solved