Protected Forms & Tab Key

[virgobiker]

How do I create a form that allows users to use the tab key to move from one
unprotected cell to the next, vs. having to use the mouse to click? Seems
simple, but I can't find the info in MS Help. Thank you.

 

[Gord Dibben]

See the info here at Bob Phillips' site.

http://www.xldynamic.com/source/xld.xlFAQ0008.html

There is another method which involves VBA Worksheet event code. If
interested in that, post back.

Gord Dibben Excel MVP