ENTER KEY CAN TAKE TAB KEY POSITION?

vipulgos

Active Member
Joined
Aug 17, 2002
Messages
335
Office Version
  1. 2010
Platform
  1. Windows
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

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
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
 
Upvote 0

Forum statistics

Threads
1,218,830
Messages
6,144,724
Members
450,567
Latest member
Mplz

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
Back
Top