#1
|
|||
|
|||
Prevent Copying and Pasting
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
|
||||
|
||||
You can set the worksheet protection to disabling the selection of locked or unlocked cells - or both. This can all be implemented via Cells|Format on the Ribbon's Home tab. What they can't select, they can't copy. Of course, that doesn't prevent printing the file or saving it to a PDF whence the content can be copied...
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
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 without macros.
|
#4
|
||||
|
||||
If you use a separate sheet for the data entry inputs, that will obviate the need for the users to have anything other than view access to the one you want to protect.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
copying and pasting Excel tables into Word | derohanes | Word | 1 | 01-24-2013 12:07 AM |
Copying and pasting from Excel | Lorna B | Word | 1 | 03-20-2012 11:58 PM |
How to Start from 1. automatically after copying/pasting a Numbered Bullet or Table | drlili | Word | 2 | 07-25-2011 09:38 AM |
Copying & Pasting to Firefox problems | mso2u | Word | 2 | 04-07-2011 07:26 AM |
Maintain formatting while copying text from word, and pasting into a webpage. | kdogg121 | Word | 1 | 07-07-2009 02:50 AM |