Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I use the tab button after protecting the worksheet?
Once I have protected the worksheet, I can't use the tab button to move from
cell to cell. Any ideas. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I use the tab button after protecting the worksheet?
Joanne,
You can only tab to cells that are UNLOCKED after protection. Make sure the sheet is NOT protected. Select all the cells that you want to be able to change when the sheet is protected (i.e. cells w/o formulas, titles, or column/row lables), click FormatCells... (Ctrl + 1), go to the Protection tab, and make sure that the Locked checkbox is unchecked. hope this helps, Conan "Joanne, BC" <Joanne, wrote in message ... Once I have protected the worksheet, I can't use the tab button to move from cell to cell. Any ideas. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I use the tab button after protecting the worksheet?
Can you not use your arrow keys? they still work under protection.
Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Leave list box unprotected while protecting worksheet | Excel Discussion (Misc queries) | |||
Macro to search for and display data in another worksheet | Excel Worksheet Functions | |||
How do I add a command button on a worksheet to "paste" from the . | Excel Worksheet Functions | |||
Macro to simply bring up the Find dialogue box?? | Excel Discussion (Misc queries) | |||
If I mistakingly click on the email button on a worksheet, how do. | Excel Discussion (Misc queries) |