Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
go from input cell to input cell
I would like the user to go from input cell to input cell. I got the answer:
protect all cells - unlock input cells, protect wkst - use tab key. I used tools/protection/protect sheet. Tab is now disabled. Is this not the correct follow through? And can I make it so the user can also use Enter to get the same results? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
go from input cell to input cell
Hi
before you protect the sheet, choose the cells that you want the user to get to and choose format / cells - go to the protection tab and choose unlocked. now protect the sheet - the tab key should take you from unprotected cell to unprotected cell. as far as i know you can't do it with the enter key. Cheers JulieD "Toinett" wrote in message ... I would like the user to go from input cell to input cell. I got the answer: protect all cells - unlock input cells, protect wkst - use tab key. I used tools/protection/protect sheet. Tab is now disabled. Is this not the correct follow through? And can I make it so the user can also use Enter to get the same results? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Input cell should display a percentage of input value in the cell | Excel Discussion (Misc queries) | |||
How to input pictures automatically based on cell input? | Excel Worksheet Functions | |||
run macro with input msg based on cell input | Excel Discussion (Misc queries) | |||
Have user input converted to uppercase in same cell as input? | New Users to Excel | |||
data validation to restrict input in cell based on value of cell above that cell | Excel Programming |