ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Protected sheet disables return key. (https://www.excelbanter.com/excel-discussion-misc-queries/139797-protected-sheet-disables-return-key.html)

GARDNERGUY

Protected sheet disables return key.
 
After typing in a row, and using the "enter" key,
the curser returns to the cell below the first cell of the row I just
finished on.
But,
when the page is protected, the curser will only drop below the last cell
typed in.
How do I get it to always return to the far left of the page and down one
cell when the sheet is protected?
I have gone into tools, otions, edit, but that doesn't do the trick.

Thanks in advance.



All times are GMT +1. The time now is 03:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com