Tabbing with in groups of cells?

[dlukaart]

Is there a way to set a group of cells to tab through on a form.
cannot tab without going all the way across the page. Any help would b
appreciated

 

[Frank Kabel]

Hi
highlight the area first. After this 'tab' through the selected area

 

[Ron de Bruin]

Hi dlukaart

If you select the range first you can use the Tab key or enter key.
Select A1:C10 for example and try it

Or in 2002/2003 you can
Uncheck locked in the group of cells
Protect you sheet and uncheck select protected cells

If you use a plder version you nee VBA code.
If you want that post back

 

[Gord Dibben]

Ron

Or in 2002/2003 you can
Uncheck locked in the group of cells
Protect you sheet and uncheck select protected cells

Works fine in Excel 97 also. Don't know about 2000.

dlukaart

Have a look at the results of a google search.

http://snipurl.com/817e

Gord Dibben Excel MVP

 

[RagDyer]

Hey Gord,

For the ocasional times when your ranges get too big, check out this old
post from Dave Peterson.

It's so simple, that even I used it.
And I'm one who stays away from code.

http://tinyurl.com/ypk2j
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
Ron

Or in 2002/2003 you can
Uncheck locked in the group of cells
Protect you sheet and uncheck select protected cells

Works fine in Excel 97 also. Don't know about 2000.

dlukaart

Have a look at the results of a google search.

http://snipurl.com/817e

Gord Dibben Excel MVP

 

[Ron de Bruin]

Hi Gord

This is not possible in 97/2000

A user can't select any cells outside the range with unprotected cell
(also not with the arrow keys)
And you don't have to select the range

 

[Gord Dibben]

Thanks Ron.

Think I mis-understood what's needed.

Gord