ExcelBanter - Protected Forms & Tab Key

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Protected Forms & Tab Key (https://www.excelbanter.com/excel-discussion-misc-queries/2491-protected-forms-tab-key.html)

virgobiker

Protected Forms & Tab Key

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

On Thu, 23 Dec 2004 18:11:01 -0800, "virgobiker"
wrote:

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.

All times are GMT +1. The time now is 02:15 AM.