Protected work shet
Click TOOLS on the menu and select OPTIONS. In the OPTIONS dialog box, click
the EDIT tab and turn on MOVE SELECTION AFTER ENTER if it isn't on, and set
the DIRECTION to RIGHT.
If you're using Excel 2000 or greater you can also set protection to only
allow users to move to unprotected cells.
--
Kevin Backmann
"Stuart Carnachan" wrote:
I have a proteced work sheet with unlocked cells where dat should be input.
Is there any to ebsure the cells are entered in descending/horizontal order
--
Stuart
|