Excel VBA - DoubleClick Event/Protected Sheet

[Jaye Cavallo]

Hello, I have developed a userform that writes data to a worksheet. The userform is working perfectly fine with adding the data to the worksheet. I have implemented a doubleclick event to the worksheet to allowing the user to edit each entry (row) that has been added to the worksheet from the userform. However, I would like to prevent users from editing the worksheet with direct interaction to the worksheet, but allow for a double click event. Is there a way to protect the worksheet, allow for the doubleclick event AND prevent the user from editing/deleting content on the worksheet?

I would appreciate any feedback.

 

[bobsan42]

protect the worksheet. have to unprotect it to write data from the form, then protect it again.
probably have to allow selecting locked cells. how did you implement the double click - have to check if it works on a protected sheet.
the other way is to have a button to open the form, i am not sure if the button can move with the selection on a protected sheet.