As my cells were still left to right, top to bottom, I thought it might be
because I had merged cells by row (i.e. A2, A3, A4, A5) to allow for the
height of the column headings. I took out the merged cells, made one row for
all my column headings and adjusted the height to the maximum I needed for
the longest wrapped heading. The tabs now go to the next unlocked cell after
the drop down list cells. I have other merged cells within the template
which worked, but those are merged by column (i.e. A2, B2, C2). Thanks
again! Have a great weekend!

"Gord Dibben" wrote:

That's the problem with using the protection feature to Tab to unlocked cells.

The order must be left to right and top to bottom.

There are a couple of other methods.

See Bob Phillips' site for another using a named range.

http://www.xldynamic.com/source/xld.xlFAQ0008.html

Also, there is event code which can take you through cells in a pre-defined
order.

Post back for code if you would like to try that.


Gord Dibben MS Excel MVP

On Fri, 1 Jun 2007 13:14:01 -0700, frpkaren
wrote:

I've set up a protected Excel template with locked cells so users can tab to
the cells that need to be filled in. I have five columns in which they
wanted to have a drop down list so they can select the appropriate heading
for each column. Once you tab to the last of these columns with the drop
down list, the next tab takes you to the first of these five columns instead
of going to the next cell to be filled in. You can click into the next
unlocked cell, but I'd rather have the users still be able to tab to the next
unlocked cell.