Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
tab button not working in excel
Help! I've done something weird in an excel spreadsheet. I don't know what
I did, but the tab key stopped working. I reset the transition key checkmark in toolsoptionstransition, and now it tabs, but it not from field to field...meaning instead of going from A1 to B1, it goes from A1 to Q1 or W1!! I don't think it is password protected, although I am not the only user to have acess to it. Any ideas would be GREATLY APPRECIATED!!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
tab button not working in excel
Traci
If any of the cells are unlocked (FormatCells...ProtectionLocked = unchecked) and the worksheet locked then the tab key will tab between cells that are unlocked. Is this the default behaviour in a new workbook? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Traci" wrote in message ... Help! I've done something weird in an excel spreadsheet. I don't know what I did, but the tab key stopped working. I reset the transition key checkmark in toolsoptionstransition, and now it tabs, but it not from field to field...meaning instead of going from A1 to B1, it goes from A1 to Q1 or W1!! I don't think it is password protected, although I am not the only user to have acess to it. Any ideas would be GREATLY APPRECIATED!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can excel have a button to input (stamp) the systems date and/or . | Excel Worksheet Functions | |||
Visio button message in Excel | Excel Discussion (Misc queries) | |||
excel 2003 slow when working with excel 2000 files | Excel Discussion (Misc queries) | |||
Excel: Change content A1 with B1 by pressing one button <- | Excel Worksheet Functions | |||
can't find map button in Excel in Office Standard Edition 2003 | Excel Worksheet Functions |