Prevent copy of formulas on a worksheet

G

Guest

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.
 
G

Guest

Before you protect the formulas format the cells, under protection click
hidden, this will hide the formulas, and the results will still show
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

FORMULAS PROTECTION IN EXCEL WORKSHEET 12
Hiding Formulas and Being Able to Make Changes 2
Easy question - copying worksheet and keeping formulas 2
Protecting Formulas in Tables 2
Displaying BOTH formulas and values 6
Copying a range of data without adjusting formulas 16
copy formulas to another workbook 2
Freeze Formulas - Replace Worksheet 5

Top