Tab Order
 

It is possible to only allow users to select unprotected cells. Is it
possible for the tab order to be set to down columns and then across rows,
rather than the standard across rows down columns?

EA

Tab Order
 

the closest option you have is under tools=Options=Edit tab where you can
designate the direction of movement after the Enter key (but this doesn't
affect the tab key).

The other alternative is to use the Ctrl Key to select the cells in the
order you want to progress through them. then assign this selection to a
named range. Then write code to select this range and maintain it or write
code to manage the selection itself. Either would probably utilize the
selectionchange event and be easily frustrated by disabling macros.

--
Regards,
Tom Ogilvy


"EA" wrote:

It is possible to only allow users to select unprotected cells. Is it
possible for the tab order to be set to down columns and then across rows,
rather than the standard across rows down columns?

EA