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*

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*

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*

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*

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*