Disable Copy Paste

    I've seen a a few ways to disable copy paste in a workbook, some work and some don't work.

    And now that I have Office 365, and upgrading some logic on a few workbooks.......


    What is the best, or tried and true way to disable users from copy and paste, as well as disabling the context menus (right click)


    Hope all is having a good day!


    Thanks!

  • Carim

    Changed the title of the thread from “Via VBA” to “Disable Copy Paste”.

    Once you have tested the macro, feel free to share your comments

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Quote from Carim

    Hello,


    Attached is a very effective solution designed by Ken PULS


    Hope this will help :)

    I'm not the OP but thanks Carim and kudos to Ken PULS on an elegant solution.


    This is exactly what I was searching for - it allows Paste Special Values from the right-click context menu but prevents all other paste or drag/drop actions that would make undesirable formatting changes. Also very tidily toggles everything back on with the Workbook_Deactivate and Workbook_BeforeClose events so the effect is limited to the active workbook.


    Thanks again :thumbup:  8)

    Hi and Welcome to the Forum :)


    Very pleased to hear that could help you out ...!!!


    You are right : Ken PULS has designed a brilliant macro :thumbup:

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

  • Kyp

    Selected a post as the best answer.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login