unlocked cells

[andrewkerr84]

hi
i have a protected worksheet with some unlocked cells for input of
data, if i hit the tab button i step thru the unlocked cells
horizontally row by row, if i press enter i step thru them vertically
column by column - is there anyway of dictating the order cells are
visited after the input of data??

for example after inputting data into cell a1, the next unlocked cell
might be b1, is there a way of jumping direct to z10 after pressing the
enter button, instead of b1?

thanks

andrew

 

[Paul B]

andrew, hava a look here,

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

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003