ENTER KEY CAN TAKE TAB KEY POSITION?

vipulgos

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

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

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,181,335
Messages
5,929,377
Members
436,665
Latest member
MonkeyNotDonkey

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