Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I prevent data i a cell from being copied?
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I prevent data i a cell from being copied?
Hi,
You are unlikely to find a bullet proof method because protection in Excel is not very robust but one deterrent would be to protect your sheet with the option of not allowing users to select locked cells. Another method is to use the code written by Ken Puls which disables the copy/paste options. But once again the wheels come off if the user doesn't enable macros when the workbook is opened. http://www.vbaexpress.com/kb/getarticle.php?kb_id=373 Mike "Bo J Eriksson" 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. |
#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. |
Reply |
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) |