Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protected Sheet TAB issue
Is there a way when I protect a sheet to allow the TAB key to work so that I
can tab through cells? -- You want it done by when? *laughs* |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protected Sheet TAB issue
ToolsProtectProtect sheetCheck Select locked cells. It' default in Excel
2003: Regards, Stefi €˛Dispatcher Scott€¯ ezt Ć*rta: Is there a way when I protect a sheet to allow the TAB key to work so that I can tab through cells? -- You want it done by when? *laughs* |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protected Sheet TAB issue
Hi,
You can't do that, you can only Tab between unlocked cells on a protected sheet but you can still use the arrow keys providing the option to select locked cells is selected when protecting. Mike "Dispatcher Scott" wrote: Is there a way when I protect a sheet to allow the TAB key to work so that I can tab through cells? -- You want it done by when? *laughs* |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protected Sheet TAB issue
Sorry, I didn't test what I said!
Stefi €˛Mike H€¯ ezt Ć*rta: Hi, You can't do that, you can only Tab between unlocked cells on a protected sheet but you can still use the arrow keys providing the option to select locked cells is selected when protecting. Mike "Dispatcher Scott" wrote: Is there a way when I protect a sheet to allow the TAB key to work so that I can tab through cells? -- You want it done by when? *laughs* |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protected Sheet TAB issue
A 'sneaky' way to do what you want, and this is assuming that you have a
large worksheet, is to do as follows: 1 Select what 'tab' points you want to have, these cells should be blank and have no bearing on any calculations, etc (white space). 2 Unlock these cells. 3 Add data validation to these cells, with Validation Criteria Allow: Text Length, Data: Less than, Maximum: 1 4 Re-protect the sheet. NOTE: Yes, DV is still limited by people being able to copy from somewhere, and paste into a DV cell no matter the DV, it is why it is important that these cells not be relevant to any calculations. -- John C "Dispatcher Scott" wrote: Is there a way when I protect a sheet to allow the TAB key to work so that I can tab through cells? -- You want it done by when? *laughs* |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sheet Information - Is sheet protected? | Excel Discussion (Misc queries) | |||
Protecting a Sheet - Issue | Excel Worksheet Functions | |||
Protected sheet to unprotected sheet | Excel Worksheet Functions | |||
simple time sheet issue | Excel Discussion (Misc queries) | |||
Printing issue in Excel Sheet | Excel Discussion (Misc queries) |