Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stop next cell being selected on Enter
I have a sheet which has only 3 input cells, but only one input cell is
required for a user in a given state. I've disabled the "move selection after enter" function in tools/option/edit and when they enter a value and press enter the active cell stays the same - which is what I want. When I protect the sheet, the active cell jumps to the next unprotected cell. How can I stop it doing that? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stop next cell being selected on Enter
I don't know why Excel reacts this way, but when the worksheet is protected,
make sure that the user is allowed to select both locked and unlocked cells. They still won't be able to make changes to the locked cells, but this will prevent the cursor from moving. "Ken G." wrote in message ... I have a sheet which has only 3 input cells, but only one input cell is required for a user in a given state. I've disabled the "move selection after enter" function in tools/option/edit and when they enter a value and press enter the active cell stays the same - which is what I want. When I protect the sheet, the active cell jumps to the next unprotected cell. How can I stop it doing that? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stop next cell being selected on Enter
OK thanks Jeff, that works, but I've just realised that disabling the "move
to after enter" doesn't live in the particular worksheet but is saved as a global preference - not really a good idea. I'll see if I can come up with a macro to stay in the same cell after enter - or of course anyone else feel free to beat me to it. "Jeff Stevens" wrote: I don't know why Excel reacts this way, but when the worksheet is protected, make sure that the user is allowed to select both locked and unlocked cells. They still won't be able to make changes to the locked cells, but this will prevent the cursor from moving. "Ken G." wrote in message ... I have a sheet which has only 3 input cells, but only one input cell is required for a user in a given state. I've disabled the "move selection after enter" function in tools/option/edit and when they enter a value and press enter the active cell stays the same - which is what I want. When I protect the sheet, the active cell jumps to the next unprotected cell. How can I stop it doing that? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Selection after "Enter" | Excel Discussion (Misc queries) | |||
How to move to next cell by entering data-not using Enter key. | Excel Discussion (Misc queries) | |||
How to move to next cell by entering data-not using Enter key. | New Users to Excel | |||
how read value from last selected cell? It is possible? how get adress last selected cell? | New Users to Excel | |||
enter a time into a cell, have the cell show two times the entry | Excel Worksheet Functions |