Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to use selection change instead of double click event? | Excel Discussion (Misc queries) | |||
How to change syperlink from single click to double click | Excel Worksheet Functions | |||
Click on graph bar to execute a double-click in a pivot table cell | Charts and Charting in Excel | |||
UserForm TextBoxes (with ControlSource set) won't clear in one click | Excel Programming | |||
Mouse Over Graph, Capture Information on Click(Double Click) | Excel Programming |