AUTO TAB BETWEEN CELLS
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.
|