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.
--
HTH...

Jim Thomlinson


"Wayne" wrote:

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