View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
joaniemic joaniemic is offline
external usenet poster
 
Posts: 14
Default Assign Cell to move to

I have created a form for sales people to complete.

(a) Is there a way to lock all cells to the left and bottom of the
spreadsheet without manually locking them all? I am trying to prevent the
user from tabbing or entering to a space outside the form.

(2) When the person completing the form fills in the last box (cell) is
there a way to automatically go HOME when they hit the enter key? I know how
to do this manually, but I don't want to have each of them do that.
Thanks