MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Tabbing Through Specific Cells

January 16, 2002 - by Juan Pablo Gonzalez

Kevin asks:

Can I move from cell to another (and skip some cells) by pressing the tab key or some other key?

Lock all cells, unlock those cells where the user will enter data and then protect the sheet. That way the use can press TAB to move between unprotected cells.

You could also set the EnableSelection property of the sheet to 1 – xlUnlockedCells to prevent the user selecting anything not allowed. This will only work when the sheet IS protected.