Controlling Tab Order

[AZExcel]

Hello Friends


I have a question about controlling the tab order in a protected worksheet. The cell order is non-contiguous. I would like the user to tab in this order;


"B13", "B14", "B15", "B16", "B17", "B18", "B19", "B20", "B21", "B22", "B23", "B24", "B25", "B26", "B27", "B28", "B29", "B30", "B31", "B32", "B33", "B34", "B35", "B36", "B37")


and also in column E "E13"..."E37"


I am familiar with the lock-unlock method but I am not able to figure out how to accomplish this with non-contiguous cells.


Any suggestions would be appreciated

 

[Luke M]

I think this may be the closest to what you're looking for:

http://www.dailydoseofexcel.com/archives/2004/07/06/tab-order-of-cells/

 

[SirJB7]

Hi, AZExcel!

Additionally to what Luke M posted, those two ranges B13:B37 and E13:E37, are the only unprotected cells in that sheet? If so, just uncheck first entry in worksheet protection dialog (Select blocked cells).

Regards!

 

[AZExcel]

Luke,


Thanks for the link. I will try the code and see if it works. I will bookmark this site as well for future reference....AWESOME!


SirJB7,


I appreciate your suggestion. I previously tried to uncheck the box under protection but the tab order I get is B13-E13.... I need it to go B13-B37.

 

[AZExcel]

Luke,


The code worked perfectly.. Thanks Again !!

 

[Luke M]

Woohoo! Glad it was able to work for you, and for letting us know. =)