John, here is one way, put in thisworkbook code

Private Sub Workbook_Open()
'will not let you select locked cells
'This is a setting that Excel doesn't remember between closings,
'that is why it in the workbook open event

'change to your sheet name
With Worksheets("sheet1")
.Activate
.EnableSelection = xlUnlockedCells
.Protect Contents:=True, UserInterfaceOnly:=True
End With
End Sub


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **
"John" wrote in message
m...
What is the VBA command to do this? I want to be able to just tab over
to unlocked cells and skip locked cells completely.

I knew how to do this once, but I must have learned something new
which crowded out that bit of knowledge. Thanks for your help.

-John L.