I created a worksheet in Excel 2003 where with protection I can force editing
in only one cell. The cursor only rests in that cell, so that when typing
you don't have to first move the cursor to that cell. In an older version of
Excel, I can't do that. I can have it tell me my entry is invalid for the
cell my cursor is in. Is there a way in earlier versions to force the cursor
to only rest on a specific cell? Validation, drop-down box type things? I
can't think of the word.
Thanks, Bob