Tabbing through cells

[Len]

Is there a way to set up a form so you can tab through the form stopping only at the cells designated for input?
Thank you,
Len

 

[redneckopen]

Take a look at this post http://www.mrexcel.com/board2/viewtopic.php?t=114499&highlight=

 

[Smitty]

Sure,

Select the cells that require input and goto Format-->Cells-->Protection-->Uncheck "Locked". The goto Tools-->Protection-->Protect Sheet. Add a password if you want (keeps honest people,honest). Now your tab stops will be on those cells only.

HTH,

Smitty

 

[Len]

Thanks again,
Len