Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I hide the equations from the cells in Excel?
I want to hide all the equations which I wrote, and it is allowed when you
enter the right password. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I hide the equations from the cells in Excel?
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 On Dec 30, 10:59*am, Saif wrote: I want to hide all the equations which I wrote, and it is allowed when you enter the right password. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I hide the equations from the cells in Excel?
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 "Saif" wrote in message ... I want to hide all the equations which I wrote, and it is allowed when you enter the right password. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can trendline equations be automatically entered into cells? | Excel Worksheet Functions | |||
Protecting cells but still able to see referencing equations | Excel Discussion (Misc queries) | |||
How do I associate word cells to equations? | Excel Worksheet Functions | |||
Printing of cells in Excel with conditional equations? | Excel Discussion (Misc queries) | |||
Omit/bypass cells in column equations | Excel Worksheet Functions |