Forum Discussion
Solved
Movement in spreadsheet as form after enter
When using an Excel spreadsheet as a form, is there a way to move from one cell location directly to another cell location after pressing enter in the first cell? What I want to do is have the user ...
I could be wrong about this--not having done this in a llloonnnggg time, but if my memory serves, if you protect the sheet, but specify the cells in question as "unprotected," then the kind of movement you're suggesting happens "automatically," since those are the only cells the user is permitted to use.
I could be wrong about this--not having done this in a llloonnnggg time, but if my memory serves, if you protect the sheet, but specify the cells in question as "unprotected," then the kind of movement you're suggesting happens "automatically," since those are the only cells the user is permitted to use.
You were correct, that does work, but you have to use the TAB key instead of enter. Thank you for the fix!
