Tabbing Order of Unproteced Cells

[Wayne]

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

 

[Jim Thomlinson]

You can set the sheet such that the user can only select unprotected cells by
setting that option on the Protect Sheet dialog which appears when you
protect a sheet. That will not change the tab order only which cells tab will
take you to. The only way to change the order to something custom is to use
VBA code and that can get a bit messy if the active cell needs to jump around
a lot.

 

[Bob Umlas]

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-06-ACNJ/AdvExcelConf200906ACNJ.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

 

[Eric G]

I may be wrong, but I think the OP wants to set the tab order of going
through the unprotected cells, i.e. maybe going top to bottom instead of left
to right, etc.

I don't think that's possible in Excel - it will always go in a certain
order when tabbing through the cells. You can't set the tab order of cells
like you can set the tab order of controls on a userform, for example.

Eric