Pressing TAB or Enter Key on Protected Worksheet

[brentjohn]

Greetings,
I have a Worksheet where all the cells are Protected - I am using "Private Sub Worksheet_BeforeDoubleClick(ByVal target As Range, Cancel As Boolean)" to open several different UserForms. The issue is if the Tab or Enter keys are pressed, the Workbook "locks" up and becomes unresponsive. I am needing code that will prevent this from happening and possibly display a custom MsgBox instructing the user not to press either the Tab or Enter Key.

[mikerickson]

In your BeforeDoubleClick event, are you setting Cancel to True as well as opening the userforms?

When are the Enter keys that lock things up being pressed? When the userforms are open (are they modal or modeless)? or before?

[brentjohn]

mikerickson,
Thank you for your reply!
Yes on setting Cancel = True. Regarding the Enter Key, I just realized it is works okay. I'm not sure when the userforms are opened in modal or modeless?

[LJMetzger]

Modal UserForms lock out Excel resources (only the UserForm is active) and are started as:

Please Login or Register  to view this content.

Modeless UserForms allow access to Excel resources (you can access the Spreadsheet) and are started as:

Please Login or Register  to view this content.

Lewis