Protecting Formulas

K

Keith Camacho

I have a formula in a cell which is copied to several other cells for future
calculations. How do I prevent the formulas in those cells from being
erased? I am preparing this for others to use.
Thanks in advance.
/keith
 
J

JulieD

Hi Keith

the only method is to protect the worksheet ... basically you have to unlock
the cells you want people to get to (select them and choose format / cell /
protection tab and untick locked)
then you have to protect the worksheet
tools /protection / protect sheet
- use a password if you want to stop people from unprotecting the sheet
themselves - however, do be aware that it takes one website and about 2 mins
to break the passwords on worksheet & workbook protection.
 

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

Copy addition formula of non-consecutive horizontal cells 2
Protecting Word 2019 document 0
Display weeks from a Milestone 0
"The object was saved in an invalid format and cannot be read." 0
Help needed for inexperienced MS Excel 2003 user 2
Combining three files when middle file has sections with endnotes 2
Resctricting editing rights, but allowing those who cant edit, to still copy the slides 0
A couple questions BEFORE using Office 365 0

Top