TAB BUTTON - VBA TO SKIP CELLS
 

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

TAB BUTTON - VBA TO SKIP CELLS
 

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

HTH,
Paul


--

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

TAB BUTTON - VBA TO SKIP CELLS
 

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

"MarthaSue" wrote:

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

TAB BUTTON - VBA TO SKIP CELLS
 

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 . .

"Mike H" wrote:

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

"MarthaSue" wrote:

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