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

or
How many woodchucks could a woodchuck Chuck If a woodchuck could Chuckwood?

--
Don Guillett
SalesAid Software

"David McRitchie" wrote in message
...
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