Several ways to do this.

See the info here at Bob Phillips' site.

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

There is another method which involves VBA Worksheet event code. If
interested in that, post back.


Gord Dibben Excel MVP


On Mon, 4 Jul 2005 11:29:01 -0700, "SYBS"
wrote:

Anyone got any ideas on how to preset a tabulation order in excel. Cant find
it anywhere.