Moved automatically to the next specified cell

[Fred's]

Hello,

Is it possible, in Excel 2002, to enter data only into some cells, and
then be moved automatically to the next specified cell?

Also, I want that all the other cells of the sheet that are not used
to be locked.

Thanks for your help!
Fred's

 

[Stefi]

Unlock used cells (Formats>Cells>Protection Tab)
Protect worksheet (Tools>Protection>Sheet protection)
Pressing Tab key moves cursor to the next unlocked cell on a protected sheet.

Regards,
Stefi

„Fred's†ezt írta:

 

[Fred's]

Unlock used cells (Formats>Cells>Protection Tab)
Protect worksheet (Tools>Protection>Sheet protection)
Pressing Tab key moves cursor to the next unlocked cell on a protected sheet.

Regards,
Stefi

„Fred's” ezt írta:









- Afficher le texte des messages précédents -

- - - - - - - -

Thank you for your help!

Last question. Is it possible to choose the way the cells are moving??

Thank you.

 

[Stefi]

It requires VBA scripts (event macros).

Stefi


„Stefi†ezt írta:

 

[Gord Dibben]

You can choose the order of the unlocked cells to move to if you create a
named range.

See Bob Phillips' site for more info on this mehtod.

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

Note: it says "without protection" but you can also use the method with
protected sheet.


Gord Dibben MS Excel MVP