Results 1 to 3 of 3

Thread: Prevent Copying and Pasting

  1. #1

    Prevent Copying and Pasting



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I want to hand out an MS Excel investment model to my fellow students for a university assignment. I want to prevent them from copying and SPECIFICALLY PASTING when I send out the financial model. How can I do this?

    I am also trying to avoid to use VBA.

    Thank you in advance.

  2. #2
    Conjurer Simi's Avatar
    Join Date
    Feb 2012
    Location
    Utah, USA
    Posts
    187
    Articles
    0
    you can lock the cells of the workbook, so they can't select them. If they can't select them they can't copy them.

  3. #3
    I have tried that. Unfortunately, there is information / numbers that are needed to be entered in each cell. The formulae were put into each cell through data validation. I have realised that it may be prudent to block / prevent pasting.

Posting Permissions

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