Can I change the tab order in a protected worksheet?
 

I would like to be able to change the tab order when entering data in a
protected worksheet. The default is to tab across the page and then to the
next row. There are some instances where I need to go down and then across.

Check out Bob Phillips' site for methods.

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

Note: there is another method using event code in a worksheet module.

Post back if you want to consider that.


Gord Dibben Excel MVP

On Tue, 17 May 2005 10:15:28 -0700, "sciservice"
wrote:

I would like to be able to change the tab order when entering data in a
protected worksheet. The default is to tab across the page and then to the
next row. There are some instances where I need to go down and then across.