Tab movement

[Guest]

I am working on an employee time sheet and have locked all the necessary
cells. I would like to TAB thru the unlocked cells up and down instead of
from left to right, is this possible??

 

[Chip Pearson]

What version of Excel are you using? In Excel 2002 and later, you
can choose "Select Unlocked Cells" and clear "Select Locked
Cells" from the Protection dialog.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Guest]

Chip Thanks for the quick reply I am using 2000, All I want is to tab
through in the logical progression of data entry.

 

[Gord Dibben]

Not using the TAB key. It always moves left to right and top to bottom.
TAB works fine if unlocked cells are in one column.

You could use a named range to set the logical order and use the <ENTER> key.

See http://www.xldynamic.com/source/xld.xlFAQ0008.html

OR worksheet_change event code similar to

''moves from C2 through E5 at entry
Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Target.Address
Case "$C$2"
Range("C5").Select
Case "$C$5"
Range("E2").Select
Case "$E$2"
Range("E5").Select
End Select
End Sub


Gord Dibben Excel MVP

 

[Guest]

Thanks Gord, that was exactly what I needed!!!!!

Not using the TAB key. It always moves left to right and top to bottom.
TAB works fine if unlocked cells are in one column.

You could use a named range to set the logical order and use the <ENTER> key.

See http://www.xldynamic.com/source/xld.xlFAQ0008.html

OR worksheet_change event code similar to

''moves from C2 through E5 at entry
Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Target.Address
Case "$C$2"
Range("C5").Select
Case "$C$5"
Range("E2").Select
Case "$E$2"
Range("E5").Select
End Select
End Sub


Gord Dibben Excel MVP