| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to protect cells from being copied or cut
I have a data that is entered on a daily basis by others. I need to keep them
from being able to copying or cutting and pasting existing data from one cell or goup of cells to another. I can protect the cells from everything but copying or cutting. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to protect cells from being copied or cut
You can't without getting into macros. If you want a macro solution then
something like this should do... right click the sheet tab and select View Code. Paste the following. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Application.CutCopyMode = False End Sub -- HTH... Jim Thomlinson "Chris" wrote: I have a data that is entered on a daily basis by others. I need to keep them from being able to copying or cutting and pasting existing data from one cell or goup of cells to another. I can protect the cells from everything but copying or cutting. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you protect an excel document from being burned or copied? | Excel Discussion (Misc queries) | |||
| insert copied cells | Excel Discussion (Misc queries) | |||
| How to use macros to copy a range of cells which can exclude some cells which I didn't want to be copied? | Excel Worksheet Functions | |||
| How to protect a worksheet from being copied to another worksheet | Excel Discussion (Misc queries) | |||
| How do I protect a worksheet from being copied & pasted? | Excel Discussion (Misc queries) | |||
Linear Mode
