I have a fairly simple spreadsheet that I have protected columns with
formatting symbols. I want the users to only enter single digit values
into the unprotected cells and automatically skip the protected cells
containing a "," or ".". This seems to work when I use the TAB key.
However, if I press the Right Arrow or Enter key, I can end up on a cell
that is protected.
My question:
Is there a way to force the ENTER and RIGHT ARROW keys to behave as if a
TAB was pressed?