Using tab key in protected worksheet
 

I have a worksheet that I am allowing users to edit only certain cells. In
the protected mode, the tab key won't work, only the arrows and enter key.
Any ideas what I need to get this function back? Thank you.

Using tab key in protected worksheet
 

You have some cells that are unlocked and you want to Tab to those cells?

I don't know why your Tab key will not do that.

Have you tried a different keyboard?


Gord Dibben MS Excel MVP

On Wed, 24 Jun 2009 12:14:01 -0700, bev
wrote:

I have a worksheet that I am allowing users to edit only certain cells. In
the protected mode, the tab key won't work, only the arrows and enter key.
Any ideas what I need to get this function back? Thank you.

Using tab key in protected worksheet
 

Yes I have tried different workstations. The tab key works if the worksheet
is changed back to unprotected but not in the protected mode.

"Gord Dibben" wrote:

You have some cells that are unlocked and you want to Tab to those cells?

I don't know why your Tab key will not do that.

Have you tried a different keyboard?


Gord Dibben MS Excel MVP

On Wed, 24 Jun 2009 12:14:01 -0700, bev
wrote:

I have a worksheet that I am allowing users to edit only certain cells. In
the protected mode, the tab key won't work, only the arrows and enter key.
Any ideas what I need to get this function back? Thank you.

Using tab key in protected worksheet
 

In sheet protection did you check the "select unlocked cells" under "allow
user to:"

I'm out of ideas.............Tab key has always worked for me on a protected
sheet.


Gord


On Thu, 25 Jun 2009 05:20:01 -0700, bev
wrote:

Yes I have tried different workstations. The tab key works if the worksheet
is changed back to unprotected but not in the protected mode.

"Gord Dibben" wrote:

You have some cells that are unlocked and you want to Tab to those cells?

I don't know why your Tab key will not do that.

Have you tried a different keyboard?


Gord Dibben MS Excel MVP

On Wed, 24 Jun 2009 12:14:01 -0700, bev
wrote:

I have a worksheet that I am allowing users to edit only certain cells. In
the protected mode, the tab key won't work, only the arrows and enter key.
Any ideas what I need to get this function back? Thank you.

Using tab key in protected worksheet
 

Yes I have this checked.

"Gord Dibben" wrote:

In sheet protection did you check the "select unlocked cells" under "allow
user to:"

I'm out of ideas.............Tab key has always worked for me on a protected
sheet.


Gord


On Thu, 25 Jun 2009 05:20:01 -0700, bev
wrote:

Yes I have tried different workstations. The tab key works if the worksheet
is changed back to unprotected but not in the protected mode.

"Gord Dibben" wrote:

You have some cells that are unlocked and you want to Tab to those cells?

I don't know why your Tab key will not do that.

Have you tried a different keyboard?


Gord Dibben MS Excel MVP

On Wed, 24 Jun 2009 12:14:01 -0700, bev
wrote:

I have a worksheet that I am allowing users to edit only certain cells. In
the protected mode, the tab key won't work, only the arrows and enter key.
Any ideas what I need to get this function back? Thank you.