LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.misc
Bob Simpson
 
Posts: n/a
Default Move cursor through all unprotected cells in a protected works

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Protect Workbook vs Worksheet?? Dan B Excel Worksheet Functions 3 November 7th 05 09:02 PM
Locked & protected cells still can be changed Amenity Dana Excel Worksheet Functions 0 November 3rd 05 01:56 PM
excel contents cells on different worksheet like a comment Church Administrator Excel Discussion (Misc queries) 1 August 31st 05 08:48 PM
Comparing a list to a Calendar worksheet. PatrickL Excel Worksheet Functions 0 August 25th 05 04:21 PM


All times are GMT +1. The time now is 12:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"