Thread: Tab indexing
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default Tab indexing

Select the cell you want to have data entered into and click FORMAT in the
menu & select CELLS. Click the PROTECTION TAB and remove the check from
LOCKED check box and click OK.

Then click TOOLS in the menu and select PROTECTION/PROTECT SHEET. Remove
the check from the SELECT LOCKED CELLS checkbox, add a password if you want
and click OK. The tab key, the enter key or any cursor key will only move
the selection pointer to the next unprotected cell in the worksheet.
--
Kevin Backmann


"ibgolfn" wrote:

I think that is what it is called.

How do I get the focus to go through a defined sequence of cells after
hitting tab or enter.

I have made a Questionaire with cells to accept the answers. I would like
the users to be able to jump from one "answer cell" to the next with only one
key stroke (either tab or enter).

Thanks,

Scot