Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If you unlock those three cells (Format Cells Protection tab, untick
Locked) then protect the worksheet (Tools Protection Protect Sheet), then the tab button will cycle through those 3 cells. A possible drawback with this is that the user will ONLY be able to enter data in those 3 cells. On the other hand this could be an advantage :-) -- Ian -- "Tom T" wrote in message ... I have a spreadsheet that I have three cells that I have limited the number of characters/numbers that can be put in each cellt hrough vailadation. Is there a way that when a person inputs the required characters/numbers that the tab will go to the next cell? I have looked at another question similiar to mine but that code does not work. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to Sum-If when the cells to sum are Auto-filter visable cells? | Excel Discussion (Misc queries) | |||
is there a way to auto copy cells similar to auto sum? | Excel Worksheet Functions | |||
Auto Protecting cells & auto filling date | Excel Discussion (Misc queries) | |||
How do I auto size cells? | New Users to Excel | |||
Auto populate cells based on 2 cells division. | Excel Discussion (Misc queries) |