ENTER KEY CAN TAKE TAB KEY POSITION?

vipulgos

Active Member
Joined
Aug 17, 2002
Messages
328
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.
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

XL-Dennis

Well-known Member
Joined
Jul 27, 2002
Messages
1,920
vipulgos,

Can You provide the board with Your code?

Kind regards,
Dennis
 

stevebausch

Well-known Member
Joined
May 11, 2002
Messages
810
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
 

Forum statistics

Threads
1,144,360
Messages
5,723,903
Members
422,526
Latest member
edminty84

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top