View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary Brown Gary Brown is offline
external usenet poster
 
Posts: 178
Default Moving between cells

Select...
ToolsProtectionProtect Sheet
Uncheck the item that says 'Select Locked Cells'.
Make sure the the item that says 'Select unlocked Cells' is checked.
Select 'OK'

--
HTH,
Gary Brown

If this post was helpful to you, please select ''YES'' at the bottom of the
post.



"Dave" wrote:

Some years ago I set up a spreadsheet with cetain 'unprotected' cells, and
was able to set it up such that the user automatically moved from unprotected
cell to the next unprotected cell after entering data and then pressing
Enter. ie they couldn't even place the cursor on a protected cell.
Unfortunately I can't find how to do this now.

Any ideas please?
--
Dave P