Try this:
1. While holding down the Ctrl key, click on the cells one
by one in the pre-determined direction.
2. Click on the name box in the upper left-hand corner
(where you see a cell reference), type in a name
like "myrng", and press Enter.
3. Go to Format Cells and unlock the cells.
4. Go to Tools Protection and protect the sheet.
5. You can now click on the name "myrng" from the name box
and tab through your cells.
HTH
Jason
Atlanta, Ga
-----Original Message-----
Can I tell Excel where I want it to tab to? I have locked
cells and when I
tab to the next field I want to tell it which field to go
to next.
Thanks,
PatS
.
|