Skip cells with Tab/Shift+Tab

  • Thread starter Thread starter Wescotte
  • Start date Start date
W

Wescotte

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

Eric
 
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
 
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.
 
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
 
Back
Top