Only the one method outlined at Bob's site uses sheet protection and unlocked
cells.

The named range method does need sheet protection.

The Case Select method which is now working for you does not use sheet
protection either.

Gord


On Tue, 20 Feb 2007 12:40:23 -0800, Carl wrote:

Gord, I don't know what changed but the "case select" method is working now.

"Gord Dibben" wrote:

Surely can.

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

Just keep adding cases and ranges.


Gord

On Fri, 29 Dec 2006 14:26:01 -0800, Costi
wrote:

Thanks Gord, could you please provide the example of the Sheet_change code?
Costi

"Gord Dibben" wrote:

See Bob Phillips' site for info on using a named range.

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

There is also sheet_change code that will leap around in any order you like.

If you want an example of that, post back.


Gord Dibben MS Excel MVP

On Fri, 29 Dec 2006 10:30:01 -0800, Costi
wrote:

I have created a form with Excel. I need to know if I can plan the path of
the cursor so that when the user presses Tab, the cursor goes to a
predetermined cell (Or group of cells) rather than just move logically to the
next unprotected cell.

Thank you