Thank you. I can probably use that in the future, however, there are too
many fields, and this only worked with the first 28 fields. I think I have
around 56 fields that I need to tab through.
"Paul B" wrote:
wikgarden, here is one way
Click on each cell in the tab order you would like while
holding down the Ctrl key. Now press Ctrl+F3 and give it
a defined name. Select that name from the namebox and tab
through the cells.
There is a limit of about 25-40 cells you can put into a Named Range due to
a
255 character limit in the Named range.
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"vikgarden" wrote in message
...
I have unlocked certain cells and protected the worksheet, however, I would
like to manipulate the Tab order on the unlocked cells.
Is there a way to do that? (I know I can in Access, but can't figure out
how to in excel)
Please help
|