Locking and Protecting and NOT displaying formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to not only lock but also NOT display some formulas we have in
a ROI-Return On Investment-spreadsheet???

Sum of the formulas are proprietary and would like them to not even be
displayed within the spreadsheet that will be distributed to prospects leads.

Let me know.

Thanks!
 
RTP, format, cells, protection, check hidden for the cells with formulas,
protect the sheet. be aware that this protection is VERY weak and can be
broken easily.

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
I will preface this by saying that Excel's sheet and book protection is very
weak and passwords easily cracked.

Also, what's to prevent someone from just copying the cells and pasting to a
new sheet?

If you don't want someone to access your formulas, remove them before
distribution.

But yes, you can hide them.

Select the cells and Format>Cells>Protection. Checkmark Locked and Hidden.

Protect the sheet under Tools>Protection.


Gord Dibben Excel MVP
 
Back
Top