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.

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.

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.