Hide Formulas

A

anurag.d

Hello People,
I have written some complex formulas which I dont want other people t
view.
However the results should get displayed in the same cells minus th
formulas.

I think this is possible.But cant figure out how??

Plzz help fast!!

Thanks in advance.....
 
A

Andy Wiggins

Format > Cells : Protection - Hidden
Tools > Protection > Protect Sheet

You might also want to use a password, but it's not necessary if you just
want to hide the formulas.


--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"
 
D

DNF Karran

In the cell format menu, go to protection and tick the "hidden" chec
box. Next, protect the worksheet.

Dunca
 
M

macropod

Hi,

Use Format|Cells|Protection and check the 'hidden' option. For any cells you
want users to be able to edit, uncheck the 'locked' option. Then use
Tools|Protection|Protect, with your preferred password, to protect the
worksheet.

Cheers
 
T

Tom Ogilvy

A different approach would be to hide this sheet using xlSheetVeryHidden for
the visible property in the properties window for the sheet (accessible from
the control toolbox toolbar). Then in a sheet that the user will see,
reference the results of the formula

=SecretSheet!B9

You might want to hide the linking formula in this cell as well to decrease
curiosity (the others have told you how to do that). You can also hide the
formulas on the "SecretSheet" before hiding it (hide and protect the
sheet.)

Protect the structure of the workbook in Tools=>Protect=>workbook. so the
sheet can't be unhidden.

Just a caution that this level of password protection is pretty weak. Code
which will break these passwords is posted in these groups on a pretty
frequent basis.
 
Top