want to automatically skip certain cells when you hit enter
 

want to automatically skip certain cells when you hit enter
 

I don't think you can do this. However, you CAN arrange to skip cells when
you hit TAB.

Select the cells you want accessible, then go to Format Cells
Protection, uncheck Locked and click OK (or hit enter).
Go to Tools Protection Protect Sheet, enter a password if required, then
click OK.

Hitting Tab will skip to the next unlocked cell (working along rows, then
down). Also the only cells where data can be edited are the unlocked ones.

--
Ian
--
"Deedarling1960" wrote in message
...

want to automatically skip certain cells when you hit enter
 

See Bob Phillips' site for a couple of methods to set the Tab order.

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

There is also a VBA method using sheet event code if you want it.

Post back if so.


Gord Dibben MS Excel MVP


On Fri, 11 Jul 2008 08:43:03 -0700, Deedarling1960
wrote: