Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Range quest. | Excel Discussion (Misc queries) | |||
Sum Product Quest: include an OR? | Excel Discussion (Misc queries) | |||
Protect Workbook Vs Protect Sheet | New Users to Excel | |||
Can I protect columns w/in a "List" using Protect Sheet? | Excel Discussion (Misc queries) | |||
My Quest with Time!! | Excel Worksheet Functions |