Angela

See Bob Phillips' site for info on using a named range or sheet protection.

http://www.xldynamic.com/source/xld.xlFAQ0008.html

There is also sheet_change code that will leap around in any order you like.

If you want an example of that, post back.


Gord Dibben MS Excel MVP

On Thu, 4 Jan 2007 11:05:02 -0800, AngelaD
wrote:

I created several forms in Excel (not using any templates) and now I am
trying to gray out cells, and use the TAB key to easily navigate from cell to
cell that requires inputted data.

I cannot figure out how to do this, like I have done in MS Word before.

Suggestion and help much appreciated!
Angela Davis