+ Reply to Thread
Results 1 to 5 of 5

disable coppy and past

  1. #1
    Registered User
    Join Date
    05-16-2012
    Location
    melbourne
    MS-Off Ver
    Excel 2007
    Posts
    12

    disable coppy and past

    good morning all

    A easy one I think

    Is there a way to disable CTRL C & CTRL V

    Regards Scott

  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

    Re: disable coppy and past

    Good evening sad212

    What about the other copy and paste functions, eg right click context menu, or from the toolbar?
    Ivan F Moala gives a solution here that will work just fine with Excel 2003.

    HTH

    DominicB

  3. #3
    Registered User
    Join Date
    05-16-2012
    Location
    melbourne
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: disable coppy and past

    The girls that use the sheets are on touch screens and have been trained to use keyboard short cuts only so CTRL C/V will get %90 of them. Thanks for the link it looks good I will give it a go when I get to work tonight

    Regards

    Scott

  4. #4
    Registered User
    Join Date
    05-16-2012
    Location
    melbourne
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: disable coppy and past

    good morning all

    i have run in to a small issue the link from dominicb
    Ivan F Moala gives a solution here that will work
    works to well it seams to have disabled copy and paste for all of excel not just the 2 workbooks.

    If i restart my computer I have copy and paste but after I use this workbook I loose it even after closing the book

    if i am corect i will need to add a line of code to enable copy and past on exit but are not 100% on how to do so both codes used are bolow

    the workbook code is

    Please Login or Register  to view this content.
    and Module 2 is

    Please Login or Register  to view this content.
    thanks for any help

    Regards

    Scott

  5. #5
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Re: disable coppy and past

    hi sad,
    I'd use
    http://www.xcelfiles.com/VBA_Quick13.html)
    Please Login or Register  to view this content.
    Last edited by john55; 05-26-2012 at 09:49 AM.
    Regards, John55
    If you have issues with Code I've provided, I appreciate your feedback.
    In the event Code provided resolves your issue, please mark your Thread as SOLVED.
    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

    ...enjoy -funny parrots-

+ 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