Tab orders

  • Thread starter Thread starter jontait
  • Start date Start date
J

jontait

Hi,

Is there any way to set the Tab order in a worksheet? I've got
spreadsheet where there's quite a few cells for the users to enter inf
into and others where I definately don't want them to enter or chang
any of the huge nested IF statements I've created.

Therefore:

1. Can I set the tab order so when the user opens up the spreadshee
(as a template) the cursor will be in the first cell, then they hit ta
and it moves to the next cell and so on, also I'd like to move from th
last cell within one sheet to the next cell in the next sheet.

2. Is there anyway to make sure that users can not alter the cells wit
the IF statements in them, can I make sure that they can not change th
cells I don't want them to but at the same time make the rest of th
worksheet editable.

As you can probably tell I'm not that experienced with Excel and woul
like some help, in anticipation of your replies - THANK YOU!

Jo
 
Hi
for your second question try the following:
- select all cells for which an entry should be ALLOWED
- goto 'Format - Cells - Protection' and uncheck 'Locked' for these
cells
- goto 'Tools - Protection' and protect your worksheet
 
Gord Dibben usually prescribes this method.

Multi-select (i.e. while holding CTRL) the cells in order, *but* select the
second one first then through to the last one and finally select the first
one.

Name this e.g. "Input" using the Name Box. Once the sheet is protected, you
can select the range (use Name Box dropdown) and tab through it. Frank
covered the other part.

Tip for huge nested IFs ; you can set the format of cells to locked *and*
hidden.

Rgds,
Andy
 
Thank you both very much for your help, I thought I'd set this to e-mai
me when i got a response but it didn't so sorry for the delay i
showing my appreciation.

Now just got to get to grips with Visual Basic for the othe
functions;

I'd like to be able to place a control box on the page where a user
once they've clicked it, will launch a PDF documents, called lets sa
"test.pdf", the file would be stored in "c:/excel/"

Any ideas? I'll also post this on the forum but if you know the answe
then THANK YOU once again!

Jo
 
Back
Top