How can I hide the equations from the cells in Excel?

  • Thread starter Thread starter Saif
  • Start date Start date
S

Saif

I want to hide all the equations which I wrote, and it is allowed when you
enter the right password.
 
Select the cell(s) with formulae in and then Format | Cells |
Protection tab and click on Hidden. Then when you apply Tools |
Protection | Protect Sheet and give a password (twice) your formulae
will not be visible. Note, though, that Excel's protection is pretty
weak and can easily be broken.

Hope this helps.

Pete
 
You can also enter your formula via a name and hide that name, so, for
example, if you had a formula:
=VLOOKUP(A1,$B$2:$C$100,2,FALSE), for example, you could enter a name such
as "MyFormula1" which is defined as =VLOOKUP(A1,$B$2:$C$100,2,FALSE), and
then you can enter =MyFormula1 in the cell. Then using a 1-liner in the
immediate window of the VBE, you can enter:
thisworkbook.Names("Myformula1").Visible=False
then it won't show up in the Name manager/defined name list
 
You must log in or register to reply here.

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

I can't copy and paste equations 0
Hiding VLookup #N/A 1
Hide the answer to an equation until all values are inputed 6
Excel What does E represent in Microsoft Excel?? 1
Autofill equations 4
Equations and Text in same Cell 2
Continue equation 1
Equations appear as text 1

Back
Top