When you protect it you're presented with a dialog box in which you can
specify to select locked cells or not. If you deselect this option you'll
get the behavior you're looking for.

Bob Umlas
Excel MVP

Mark your calendars for a 2-day advanced Excel conference June 17-18 '09 in
Atlantic City, New Jersey - 4 sessions of ~3 hours each led by Jon Peltier
and yours truly. Check here for details --
http://peltiertech.com/Training/2009...00906ACNJ.html
-----------
Free 1-hour Excel webinars on tips & tricks or What's new in Excel 2007:
check out http://www.iil.com/webinars/
-----------
Check out my book, "This isn't Excel, it's Magic!" on tips & tricks
in excel 2003 at:
http://www.iil.com/iil/excelmagic
or in excel 2007 at:
http://www.iil.com/iil_shortdescr.asp?sku=PT258


"Wayne" wrote in message
...
We have a spreadsheet that has protected cells (locked cells) and
unprotected
cells so that only the unprotected cells can have data entered into them.
Does anyone know if it is possible to set the order you tab through the
unprotected cells (and how to do this). Right now, it just goes through
the
cells from left to right and we want to change that.

Thanks in advance,

Wayne