We have a rather complex spreadsheet for data collection. There are
about 50 data entry cells scattered all over it, and it would be a huge
help to be able to just hit <tab to navigate from one data entry cell
to another.

This can be done, as you know, by selecting the cells in sequence while
holding down <control, then entering a name for the range. Then the
user selects that name from the little pull-down menu to the upper left
of the worksheet. This activates the range with that name, and the
first cell in the series is highlighted and ready to go. No problem
there.

Some of our users aren't exactly rocket scientists, and I must make
this absolutely as simple as possible. What I want to do, is automate
this name/range-selection process, so when the user first opens the
worksheet, that range is already activated and ready to go, without
requiring the user to select it from that little menu in the upper
left.

So the whole thing would be transparent; the user would open the
worksheet, and it would open up all ready to start tabbing and entering
data, without the user having to do anything.

Surely there's some code I can stick in there to do this. Anybody?

Ron Morgan
Austin, Texas