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

"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
"Cees" wrote in message
...
How can I change the tab sequence in a worksheet that partly consists of
protected cells and partly of unprotected cells?

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




On Thu, 26 Jan 2006 07:45:02 -0800, "Cees"
wrote:

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