Move only around selected cells??
 

I wish to create various excel sheets where the user can only move between
various cells ignoring all the others using the tab key.

for instance the first cell is A2 then when you tab it moves to C5 and all
inbetween are all locked. Is this only done by making some form (which looks
complex to me atm) or is there a very simple way of doing this?

Move only around selected cells??
 

have the cells you wnat the users to use as unlocked, lock all the other
cells and then use tools/protection and protect the locked cells
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"CP" wrote:

I wish to create various excel sheets where the user can only move between
various cells ignoring all the others using the tab key.

for instance the first cell is A2 then when you tab it moves to C5 and all
inbetween are all locked. Is this only done by making some form (which looks
complex to me atm) or is there a very simple way of doing this?

Move only around selected cells??
 

CP

Just in case you need it, you lock and unlock cells via format
cellsprotection tab.

Mike Rogers

"john" wrote:

have the cells you wnat the users to use as unlocked, lock all the other
cells and then use tools/protection and protect the locked cells
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"CP" wrote:

I wish to create various excel sheets where the user can only move between
various cells ignoring all the others using the tab key.

for instance the first cell is A2 then when you tab it moves to C5 and all
inbetween are all locked. Is this only done by making some form (which looks
complex to me atm) or is there a very simple way of doing this?