Hello.

I have a protected sheet that calls a UserForm in the Worksheet_BeforeDoubleClick event. However, when I am all said and done with the UserForm and reactivate the sheet, it gives me the password protect message (since I activated the form with a double-click on a protected cell). Is there a way to disable this? I tried:

Application.DisplayAlerts=False
...as the first code in the Worksheet_BeforeDoubleClick event, but that did not work. Is this doable, or will I need to use another event and/or object to call the UserForm?

Thanks in advance for any help.

Jason