| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I prevent data i a cell from being copied?
I don't think you will find a way to do this.
You can lock the cells and protect the sheet with no selection of locked or unlocked cells cells so users cannot select to copy but..................... User can enter =Sheet1A1 on another sheet and get the contents. Gord Dibben MS Excel MVP On Thu, 4 Sep 2008 01:36:01 -0700, Bo J Eriksson <Bo J wrote: I want to prevent data from some cells in my worksheet not to be copied to other worksheets. There are possibilities to hide and protect data not to be changed in a worksheet, but I do not find a way to prevent the data to be copied to another worksheet. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| prevent copied blank cells from replacing existing data | Excel Worksheet Functions | |||
| How to prevent copied data from appearing until triggered by anoth | Excel Worksheet Functions | |||
| how to prevent blank cell copied when combining cells? | Excel Discussion (Misc queries) | |||
| how do I prevent a worksheet from being copied in excel | Excel Discussion (Misc queries) | |||
| Prevent Hidden Column data from being copied/pasted? | Excel Discussion (Misc queries) | |||
Threaded Mode
