asked on

Controlling the position in Protected Worksheet

EE Pros,

I have protected a sheet that has a number of cells that allow for imputting data. The cells that you input data into are unprotected so as to allow one to navigate from cell to cell and input the data. Here's the question; When you go from one cell to the other, it doesn't go in the correct cell to cell path. Instead, it may go to another unprotected cell further down and not in the natural order. How do you control the cursor to go to the next logical cell?

Thank you in advance,

B.

Steven Harris

The normal tab order should be Left to Right, then Down.

If you want to change this, you can use a Macro.

For instance:

Sub SetTabKey()
'sets the arrow and tab keys
Application.OnKey "{TAB}", "NextCellSelect"
End Sub

Sub NextCellSelect()
'Go to next cell in pseudo-tab-sequence
Select Case Selection.Address
Case [cell].Address: [cell].Select
Case [cell].Address: [cell].Select
End Select
End Sub

Open in new window

Where [cell] is changed to suit your needs.

Rob Henson

There is an option that can be enabled for what happens to the cursor when enter is pressed. If you have this enabled and the movement is set to Down then the movement would go down to the next available cell.

If however you use tab on entering data rather than enter I suspect the cursor would move right first.

You could also set the movement on Enter to Right.

Thanks
Rob H

Bright01

ASKER

Thanks for the update. Rob H. where is the option? I don't think I can use a macro because I have a large number of unlocked cells I would have to identify inside the macro. For whatever reason, it doesn't behave normally like down and right.

So perhaps the option approach is worth a try.

B.

ASKER CERTIFIED SOLUTION

Rob Henson

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Bright01

ASKER

Thank you Rob!

B.