TAB BUTTON - VBA TO SKIP CELLS

[MarthaSue]

Can someone tell me the code for skipping all locked cells; using the tab key
to skip to unlocked cells . . . thanks for your time . . .

 

[PCLIVE]

The only way I know to do that is...when you protect the sheet, uncheck
"Select locked cells"

HTH,
Paul

 

[Mike H]

or you can do it how it was explained in your previous post

 

[MarthaSue]

I apoligize Mike i didn't mean to offend you, but what you had suggested is
not what i am looking for . . .there is a VBA Code that will allow the user
to hit the tab key and it will automatically skip to the next cell that
requires data entry . . but i appreciate the post . .