Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 12
Default 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!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to use selection change instead of double click event? ghost Excel Discussion (Misc queries) 1 December 26th 08 04:58 AM
How to change syperlink from single click to double click syperlinker Excel Worksheet Functions 0 June 13th 08 05:01 PM
Click on graph bar to execute a double-click in a pivot table cell [email protected] Charts and Charting in Excel 4 August 3rd 05 01:37 AM
UserForm TextBoxes (with ControlSource set) won't clear in one click Paul Martin Excel Programming 2 March 17th 05 11:55 AM
Mouse Over Graph, Capture Information on Click(Double Click) Dean Hinson[_3_] Excel Programming 1 December 6th 04 04:49 AM


All times are GMT +1. The time now is 12:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"