| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prevent copy of formulas on a worksheet
Hello,
I have a worksheet where I don't want the user to be able to modify or copy the formulas. If I lock the cells and protect the worksheet the user can't modify the formulas, but I also want to make sure that a user doesn't copy the formulas to another cell. How can I prevent the formulas from being copied? Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Prevent copy of formulas on a worksheet
Before you protect the formulas format the cells, under protection click
hidden, this will hide the formulas, and the results will still show "KAG" wrote: Hello, I have a worksheet where I don't want the user to be able to modify or copy the formulas. If I lock the cells and protect the worksheet the user can't modify the formulas, but I also want to make sure that a user doesn't copy the formulas to another cell. How can I prevent the formulas from being copied? Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Prevent copy of formulas on a worksheet
I tried that but if I copy the cell, the formula still goes with it.
I found one solution that may work. When I protect the sheet, I untick "select locked cells". Then the user can't even put their cursor on the cell. "James O" wrote: Before you protect the formulas format the cells, under protection click hidden, this will hide the formulas, and the results will still show "KAG" wrote: Hello, I have a worksheet where I don't want the user to be able to modify or copy the formulas. If I lock the cells and protect the worksheet the user can't modify the formulas, but I also want to make sure that a user doesn't copy the formulas to another cell. How can I prevent the formulas from being copied? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I copy a worksheet with formulas to another workbook? | Excel Worksheet Functions | |||
| Prevent changing size when copy&paste into another Excel Worksheet | Excel Worksheet Functions | |||
| Copy Worksheet With Formulas | Excel Discussion (Misc queries) | |||
| How to copy worksheet or workbook without formulas | Excel Discussion (Misc queries) | |||
| copy formulas to different cells in another worksheet | Excel Discussion (Misc queries) | |||
Linear Mode
