Skip cells with Tab/Shift+Tab

[Wescotte]

How would I go about specifying specific cells/rows/columns to skip
when the user presses tab or shift+tab?

Eric

 

[Tushar Mehta]

Leave the cells/rows/columns to be skipped locked. Unlock other cells
(Format | Cells... | Protection tab). Then protect the worksheet
(Tools | Protection > Protect Sheet... (might be different in different
versions of XL). In the resulting dialog box, uncheck 'Select locked
cells'.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Wescotte]

Is there any other way to do it? A few problems occur when using this
method. One, attempting do delete entire rows contents doesn't work
because of the protection on the blank cells. Two, after X rows
(somewhere around 10) instead of going to the 11th row it will flip
back up to the 1st.

 

[Wescotte]

Hmm nevermind.. I'll just use

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)

Then simply check the address of the selected cell and if it doesn't
fall into the range I want I'll just move it to the nearest valid cell.

Thanks