ENTER KEY CAN TAKE TAB KEY POSITION?

[vipulgos]

Hi,
When the sheet is protected, we can navigate the unlocked cells by TAB key, is it possible to use ENTER key instead of TAB key?
I think it should be possible by vba code "ENTER KEY BEHAVIOUR", but something going wrong with my formula.

 

[XL-Dennis]

vipulgos,

Can You provide the board with Your code?

Kind regards,
Dennis

 

[stevebausch]

I agree with XL Dennis; you guys should post the concerned code when you ask us something.

Yep, we MIGHT pick up something from your code, BUT you are ASKING us for advice.

While we wait for the OP to post code, Tools-Options-Edit Tab has a menu to select which direction the Enter key will move the cursor.

Maybe that's all it is in this situation; OP needs to set movement to Right, instead of Down.

I found that it's possible to customize movement about the sheet, but it does get tricky.

There is Worksheet .ScrollArea, .EnableSelection, also, there is Application.CursorMovement to take into consideration.

One thing to consider, if you set .EnableSelection to xlUnlockedCells, this can confuse users who are attempting to set PrintArea, if the corner cell of their desired selection is not able to be selected.

Be careful.
Steve