Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hide Formula in Formulabar
I want to hide Formula in Formulabar...
example:I apled formula in B2 to B6 Cell is "=IF(B335,"Pass","Fail")" A B 1 Number Condition 2 20 Fail 3 36 Pass 4 30 Fail 5 40 Pass 6 30 Fail 7 60 Pass Now anybody put a cell pointer in B2 to B7, "If" formula is shown in Formulabar, I want to hide my Formula for no body can see which formula is appliyed. Thanking You. |
#2
|
|||
|
|||
Hello, Rohit. Copy the cells with formulas, then on a new worksheet (or even
in same location), hit Edit--Paste special--Values. ******************* ~Anne Troy www.OfficeArticles.com "ROHIT" wrote in message ... I want to hide Formula in Formulabar... example:I apled formula in B2 to B6 Cell is "=IF(B335,"Pass","Fail")" A B 1 Number Condition 2 20 Fail 3 36 Pass 4 30 Fail 5 40 Pass 6 30 Fail 7 60 Pass Now anybody put a cell pointer in B2 to B7, "If" formula is shown in Formulabar, I want to hide my Formula for no body can see which formula is appliyed. Thanking You. |
#3
|
|||
|
|||
Hi
FormatCellsProtection and check Hidden. Now, when you protect the worksheet, formulas (and values) in cells set to be hidden aren“t shown in formula toolbar - you only can see values in cell. (When you format cells with numeric or text entries in such a way, then you can“t edit entries when the sheet is protected - you have always to replace the old entry with new one) -- Arvi Laanemets ( My real mail address: arvil<attarkon.ee ) "ROHIT" wrote in message ... I want to hide Formula in Formulabar... example:I apled formula in B2 to B6 Cell is "=IF(B335,"Pass","Fail")" A B 1 Number Condition 2 20 Fail 3 36 Pass 4 30 Fail 5 40 Pass 6 30 Fail 7 60 Pass Now anybody put a cell pointer in B2 to B7, "If" formula is shown in Formulabar, I want to hide my Formula for no body can see which formula is appliyed. Thanking You. |
#4
|
|||
|
|||
The formula bar can be removed by ToolsOptionsView and uncheck Formula
Bar. -- HTH RP (remove nothere from the email address if mailing direct) "ROHIT" wrote in message ... I want to hide Formula in Formulabar... example:I apled formula in B2 to B6 Cell is "=IF(B335,"Pass","Fail")" A B 1 Number Condition 2 20 Fail 3 36 Pass 4 30 Fail 5 40 Pass 6 30 Fail 7 60 Pass Now anybody put a cell pointer in B2 to B7, "If" formula is shown in Formulabar, I want to hide my Formula for no body can see which formula is appliyed. Thanking You. |
#5
|
|||
|
|||
Hello
Thanks for your advice... But I want to use formula in other cell (through fill handel), If we protect sheet after protect cell with hiden option,No body can editing. I want anybody use formula but they cannot know which formula is applied. Thanking you "Arvi Laanemets" wrote: Hi FormatCellsProtection and check Hidden. Now, when you protect the worksheet, formulas (and values) in cells set to be hidden arenĀ“t shown in formula toolbar - you only can see values in cell. (When you format cells with numeric or text entries in such a way, then you canĀ“t edit entries when the sheet is protected - you have always to replace the old entry with new one) -- Arvi Laanemets ( My real mail address: arvil<attarkon.ee ) "ROHIT" wrote in message ... I want to hide Formula in Formulabar... example:I apled formula in B2 to B6 Cell is "=IF(B335,"Pass","Fail")" A B 1 Number Condition 2 20 Fail 3 36 Pass 4 30 Fail 5 40 Pass 6 30 Fail 7 60 Pass Now anybody put a cell pointer in B2 to B7, "If" formula is shown in Formulabar, I want to hide my Formula for no body can see which formula is appliyed. Thanking You. |
#6
|
|||
|
|||
Hello,
Anne Troy I know that, But after paste special we cant use fill handal for use formula again. I want formula is till continieu and its cant seen anybody... thanking you "Anne Troy" wrote: Hello, Rohit. Copy the cells with formulas, then on a new worksheet (or even in same location), hit Edit--Paste special--Values. ******************* ~Anne Troy www.OfficeArticles.com "ROHIT" wrote in message ... I want to hide Formula in Formulabar... example:I apled formula in B2 to B6 Cell is "=IF(B335,"Pass","Fail")" A B 1 Number Condition 2 20 Fail 3 36 Pass 4 30 Fail 5 40 Pass 6 30 Fail 7 60 Pass Now anybody put a cell pointer in B2 to B7, "If" formula is shown in Formulabar, I want to hide my Formula for no body can see which formula is appliyed. Thanking You. |
#7
|
|||
|
|||
I don't think you can get what you want using XL. XL was never designed
or implemented as a secure platform. Even if you were to protect your sheet after applying the hidden property to your cells, that protection can be overridden by anyone with enough gumption to find these groups: http://www.mcgimpsey.com/excel/removepwords.html In article , "ROHIT" wrote: But I want to use formula in other cell (through fill handel), If we protect sheet after protect cell with hiden option,No body can editing. I want anybody use formula but they cannot know which formula is applied. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Named SUM Formula with relative refernce(s) | Excel Worksheet Functions | |||
Frequency formula | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions |