Hi Jambun,

For all practical purposes, why don't you just hide the columns that you
don't want to use, your question will be solved.

Like in your first case only open columns c to u, and hide all others.

when done, open all the columns then hide all others except columns z to aq
ans o on.

No macros ....ho headache ........just joking

--

Kind Regards,
Satti Charvak
Only an Excel Enthusiast


" wrote:

Is there a way of setting the tab order in a spreadsheet ie: I want to
tab from Column C through each column to column U, although the input
then continues from column Z to column AQ I want to operate between C
& U so that it does not jump to column Z, (Columns V,W,X,and Y are
protected to record results of formulas ). Once I have recorded the
information in the above columns I will then be moving to columns Z
through to column AQ and need to stay within these columns. I hope
that this is clear.
Thanks,
jambun