Protect Sheet Quest.
 

One prblem I am having is when I protect my
sheet so the data entry people to not type out
my formula form the cell.
One problem. It will not let them tab to the next
the adjacent cell. it seem the tab button does not
work at all.
Please advis e

Protect Sheet Quest.
 

As I recall, when a sheet is protected and you use the tab key you will be
taken to the next UNlocked cell.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Dylan @ UAFC" wrote in message
...
One prblem I am having is when I protect my
sheet so the data entry people to not type out
my formula form the cell.
One problem. It will not let them tab to the next
the adjacent cell. it seem the tab button does not
work at all.
Please advis e

Protect Sheet Quest.
 

no its not working like that, or least for me.
Easy solution is "use the arrow key"
but they have the tab key.
Any advise would help

"Don Guillett" wrote:

As I recall, when a sheet is protected and you use the tab key you will be
taken to the next UNlocked cell.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Dylan @ UAFC" wrote in message
...
One prblem I am having is when I protect my
sheet so the data entry people to not type out
my formula form the cell.
One problem. It will not let them tab to the next
the adjacent cell. it seem the tab button does not
work at all.
Please advis e