Controlling the tab order on a protected sheet?

[richrr31]

Is there a way to control the order that the TAB key goes in when in a protected sheet? It currently goes from Left to Right, then Up to Down. I would like to select the order in which it hits the unprotected cells. Is this possible?

 

[Damon Ostrander]

Hi Rich,

No, you don't need the PREVIOUS call because this routine governs the behavior after data are entered with the Enter key. You always want to go to the next cell in the tab sequence upon entering data with the Enter key.

Damon

 

[richrr31]

Got it, thanks. I've implemented all of your advice, and it looks real good. Thanks!

 

[richrr31]

When I get to a cell with a drop-down menu, I want pressing the down key to access the list so I can choose one of the options. How do I code for that?

 

[richrr31]

How do I turn this code into a loop. I have over 100 cells on some of my sheets, so typing out the lines is annoying. How do I code something like this:

array (cell1, cell2, cell3,cell4....)

currentcell =cell1
nextcell =cell2
for array 1 to end do begin
1. Case [currentcell].Address:
[nextcell].Select
2. currentcell:= nextcell
3. nextcell:= <next cell in the array>
end