Fernando,

With Excel XP or later, you can lock all the cells (Format cells, protection tab) and unlock the
cells that you want to allow the user to edit (let's say, A1 and B10). When you protect the sheet,
choose the option to only allow editing of unlocked cells, and pressing enter will move the cursor
to the next unprotected cell.

HTH,
Bernie
MS Excel MVP


"Fernandoalberte" <Fernandoalberte.1s2dsb_1121184677.8432@excelfor um-nospam.com wrote in message
news:Fernandoalberte.1s2dsb_1121184677.8432@excelf orum-nospam.com...

Guys...can someone please help me i am going crazy.

What i woudl like to do is when someone is in a workbook and they have
finished entering data into cell a1, as soon as they hit enter i woudl
like them to be taken to a cell of my choosing and not to a2 which is
the excel default.

I am sure there is a way to do this...but i just can't figure it out.

Can anyone help me?

thanks

fernando


--
Fernandoalberte
------------------------------------------------------------------------
Fernandoalberte's Profile: http://www.excelforum.com/member.php...o&userid=24493
View this thread: http://www.excelforum.com/showthread...hreadid=386474