Textboxes - restrict double-click and selection.delete
 

Hi, I have a program that creates textboxes, with the supporting data
stored on a hidden sheet. I edited the right-click menu "Edit Text"
command to call a dialog box that will update not only the text box,
but also the hidden supporting worksheet. I also added a "Delete" item

to the right click menu that also updates the backend sheet. I would
like to prevent the user from double-click the textbox to edit it, as
the back-end sheet would not then be updated. I would also like to
prevent the user from clicking on the item and hitting the delete key.
Any ideas? I would prefer not to protect the worksheet if at all
possible, as hundred of people will be using this program and I don't
want to have to deal with users accidentally protected cells they
shouldn't.

Thanks!