Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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! |
#2
![]() |
|||
|
|||
![]()
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 "RTP" wrote in message ... 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! |
#3
![]() |
|||
|
|||
![]()
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 FormatCellsProtection. Checkmark Locked and Hidden. Protect the sheet under ToolsProtection. Gord Dibben Excel MVP On Wed, 4 May 2005 14:04:02 -0700, RTP wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|