Moving from Cell to Cell
 

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!

Moving from Cell to Cell
 

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