ExcelBanter - Protected work shet

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Protected work shet (https://www.excelbanter.com/excel-discussion-misc-queries/107726-protected-work-shet.html)

Stuart Carnachan

Protected work shet

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

Kevin B

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

Stuart Carnachan

Protected work shet

kevin

Easy when you know how. Thanks
--
Stuart

"Kevin B" wrote:

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

All times are GMT +1. The time now is 09:10 AM.