Can I change the tab order in a protected worksheet?

[sciservice]

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.

[Gord Dibben]

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"
<[email protected]> 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.

[nrivera]

Gord,

I have the same question as Sciservice but the method on the xldynamic site doesn't quite work for what I'm dealing with. Is there anyway you could post the other method using event coding in a worksheet module you had offered?

Thank you,
Natasha