Hello,
Im looking for the code to disable ctrl c an ctrl v in a text box. its an active x textbox and its found on sheet1. any ideas?
Hello,
Im looking for the code to disable ctrl c an ctrl v in a text box. its an active x textbox and its found on sheet1. any ideas?
Last edited by slmi1313; 10-18-2011 at 03:05 PM.
Why use a textBox - it's simpler to use the cells.
Run DisableCutAndPaste from a suitable event procedure
(e.g. Workbook_Open or Worksheet_Activate) and EnableCutAndPaste
from another (e.g. Workbook_Close or Worksheet_Deactivate). I've not tried it on a TextBox but it should work
Please Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Thanks roy UK, but the thing is I dont want them to have the option of ctrl c or ctrl v on specific Textboxes. I was lokking around and found post talking about the key down event but I cant seem to find any code for VBA
also just tested your code, it doesn't work on a textbox, users can still use ctrl c and ctrl v
update on this, I was able to place the following code in the keydow of the textbox and this disables the use of ctrl c
issue is resolved thanks for your helpPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks