Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks Gord - your reply makes sense - I will check tomorrow - presumably
copying the file does not also copy over this instruction. David's presumption that I have not protected the sheet cannot be correct because when the cursor moves to a protected cell, a message tells me I can't write to it. As for Don Guillett woodchuck his reply in the bin. Thanks again Bob Simpson "Gord Dibben" wrote: Bob Make sure when you protect the sheet that you de-select "select locked cells". This should allow your ENTER key to jump to unlocked cells only. Gord Dibben Excel MVP On Thu, 17 Nov 2005 06:25:21 -0800, "Bob Simpson" <Bob wrote: I have Excel 2003 at home and have completed a protected worksheet with a number of unprotected cells for data entry. The cursor skips thru each unprotected cell without trawling thru the rest of the worksheet. When I copy this onto another computer at work, the cursor moves through EVERY cell, although it will display a message if I try to enter anything in a protected cell. What is set on my computer at home that is not set on the works computer? (I am using the ENTER key, not the tab or anything). Any pointers would be appreciated |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
Locked & protected cells still can be changed | Excel Worksheet Functions | |||
excel contents cells on different worksheet like a comment | Excel Discussion (Misc queries) | |||
Comparing a list to a Calendar worksheet. | Excel Worksheet Functions |