I created a spreadsheet that I need to move from each cell that I
havehighllighted. What I need to do is move to other cells... for example,
when I hit the enter key I need to go from cell E1 to B3 to D4 to D5 to B6 to
B7 to B8 then to E8 then G8, etc. I have tried to protect these cells to
move from, chose options, edit and down. These have not worked! Any help or
suggestion would be great!

Two ways I use are a

unlock the cells between which you want to cycle -use
cells...format...locked(off) and the protect the sheet
tools...protection...protectsheet.

Now press tab and it shoukld go between the cells


Option 2 :

select all the cells you want (use the control key) and make a named
range. If the range is selected tab will go around the range. Maybe do
the range selection in the sheet activate event

hope this helps


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=530715