06-24-2019 06:16 PM
06-24-2019 06:16 PM
A Family Member who uses Excel for Business work, came to me asking me why excel functions are not show up in formula bar when they click on the cell. all that appears is the value in the cell also appears in the function bar (like the cell was manually typed in the numbers) . they assure that the numbers are automatically generated from a custom function, however there isn't anything other than the values. so i have no idea where they could have gone.
heres what i know:
- excel workbook (xlsx format), macros are enabled
-VB add-in is applied to the workbook
- Showing/forcing all cells to show function, only has a few that display. but the ones they are concerned about just show a number like 30.8 (while force functions show 30.8898898955454343 and so on)
- I can get the VB modules and all the add-in and put it up (i just have to get it all together to attach) . however the workbook has private information for business, so it has to be censored if any needed to see the workbook.
Hope you can help solve
06-25-2019 01:42 AM
06-25-2019 03:27 AM
Some users prefer to hide the formulas so that no one could accidentally or intentionally modify them.
Hidding formulas is a 2 steps process:
Select the cell having the formula to hide.
Hit CTRL + 1 to open the Format Cell Dialog box
Check the box for Hidden.
On the Review Tab >> Protect Worksheet
If it is protected without password (just for unintentional modifications) then you can unprotect it from here as well. If it password protected then you need the password.
Hope that helps
06-25-2019 04:13 AM
@nabilmourad True, but if you hide a formula, the formula bar stays blank, it does not show the formula result as the poster of the question mentions.
06-25-2019 07:03 AM
@Jan Karel Pieterse wrote:
@nabilmouradTrue, but if you hide a formula, the formula bar stays blank, it does not show the formula result as the poster of the question mentions.
You are right @Jan Karel Pieterse because you will see the result in the cell itself, so what's the need of seeing it in the formula bar (as the name says it's for formulas)