help help help with cell navigation

[dodgy99uk]

I have justs tarted to create forms and i have created a sheet and it has 8 cells which i want to navigate if i am in for instance forename and i want to move = on pressing enter - to the surname cell - which is niether below or next in any way - how do i tell my sheet to do this ????

please help me i am newbie

Roger

 

[lenze]

First, select the cells where data can be entered and Choose Format>Cells. On the Protection Tab, deselect the "Locked" option. Click OK. Now Go to Tools>Protection and protect the worksheet. Now when you use the TAB key, Excel will move to the next "Unlocked" Cell. If this isn't sufficient for your needs, you will have to use VBA coding and a change event.