View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David McRitchie
 
Posts: n/a
Default Move cursor through all unprotected cells in a protected worksheet

Hi Bob,
I expect you meant skips each protected cell at home (it works),
and of course we know it does not work at work.

At work you forgot to protect the sheet. Tools, protection, protect sheet
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Bob Simpson" <Bob wrote in message ...
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