+ Reply to Thread
Results 1 to 3 of 3

Disable copy/paste

  1. #1
    Registered User
    Join Date
    12-21-2007
    Location
    Szeged, HUNGARY
    MS-Off Ver
    2013
    Posts
    43

    Disable copy/paste

    Hi all,

    I should like to know if it is possible to prevent the user of copy and paste cells instead of typing. These cells are not protected, free to type into.
    The real problem is that each cell has different validation, and after paste the validation changes.

    Thanks in advance

    Kaus

  2. #2
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Good evening KausBorealis
    Quote Originally Posted by KausBorealis
    I should like to know if it is possible to prevent the user of copy and paste cells
    Ivan F Moala provides a piece of code at his site that attempts to intecept all calls via mouse and keyboard to the cut, copy and paste commands. Have a look at the link below :

    http://www.xcelfiles.com/VBA_Quick13.html

    HTH

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.

  3. #3
    Registered User
    Join Date
    12-21-2007
    Location
    Szeged, HUNGARY
    MS-Off Ver
    2013
    Posts
    43

    Thanks dominicb

    Kaus Borealis

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1