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
On Thu, 12 Mar 2009 08:07:58 -0700 (PDT), "Fred's"
wrote:
On 12 mar, 10:56, Stefi wrote:
Unlock used cells (FormatsCellsProtection Tab)
Protect worksheet (ToolsProtectionSheet protection)
Pressing Tab key moves cursor to the next unlocked cell on a protected sheet.
Regards,
Stefi
„Fred's” ezt írta:
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- Masquer le texte des messages précédents -
- 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.