Thread
:
Moving between cells
View Single Post
#
2
Posted to microsoft.public.excel.misc
Gary Brown
external usenet poster
Posts: 178
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
Reply With Quote
Gary Brown
View Public Profile
Find all posts by Gary Brown