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.