When I only want to tab to certain areas, I format a locating cell in each
area as UNLOCKED. Use the right mouse, select format cells, go to the last
tab, and take the check mark off of Locked.

After you format the cells, you will need to protect the workbook to make
changes take affect by using the Tools menu, Protection, Protect Sheet.

The only problem is that when the sheet is protected, I don't know if your
option buttons will work unless you can also format them as unlocked.


"Dave_2k5" wrote:


I have a questionnaire I am working on in excel.

There are 24 questions in all.

I have, 7 text boxes for open answers, 14 groups of optionbuttons and 3
validation cells, which has a 'Yes' 'No' list.

What I want to do is to be able to start at the first text box which is
'name', then when the tab button is press it will go to 'department'
(the text text box) then hitting tab again will goto the first group of
optionbuttons, tab again will goto the next group of optionbuttons and
so on!!!!

How can I achive this???

Cheers,

Dave


--
Dave_2k5
------------------------------------------------------------------------
Dave_2k5's Profile: http://www.excelforum.com/member.php...o&userid=19667
View this thread: http://www.excelforum.com/showthread...hreadid=390182