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
Bookmarks