Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm using Excel 2003 for data entry, and I've been playing with using
worksheet protection to prevent some formula-containing cells from being edited during data entry. (As discussed in this thread: http://groups.google.com.au/group/mi...efe5458b5f91c3) It does what I want it to do, but with one annoying exception: When the worksheet is protected, when I reach the end of a row and press 'Enter' it does not return the cursor to the start of the next line; instead, it just moves down one cell. (It returns to the start of the next row when the worksheet isn't protected). Does anyone know why it does that? Is there a way of getting around it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to show or hide outlined data option in a protected worksheet? | Excel Discussion (Misc queries) | |||
Import external data in protected worksheet | New Users to Excel | |||
emailing excel worksheet with data protected? | New Users to Excel | |||
Data entry in multiple worksheet | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions |