Tab sequence

[Guest]

How can I change the tab sequence in a worksheet that partly consists of
protected cells and partly of unprotected cells?

 

[Otto Moehrbach]

"Tab sequence" usually means the order of the sheet tabs at the bottom of
the screen. From what you say, your "tab sequence" refers to something on
one sheet. Explain what you mean by "tab sequence". HTH Otto

 

[Gord Dibben]

Cees

There are several ways to set the TAB order on worksheet cells.

See Bob Phillips' site for methods.

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

There is another method using VBA event code.

If interested in the coding, post back for more detail and some sample code.


Gord Dibben Excel MVP

How can I change the tab sequence in a worksheet that partly consists of
protected cells and partly of unprotected cells?

Gord Dibben MS Excel MVP