LinkBack URL
About LinkBacks
Hello to all,
is this possible?
Excel formula bar to display the result of the formula, not the formula
max_max
Hello to all,
is this possible?
Excel formula bar to display the result of the formula, not the formula
max_max
No, it isn't.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Forum Rules (updated September 2018): please read them here.
How to use the Power Query code you've been given: help here. More about the Power suite here.
Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.
What about selecting a cell Right Click -> Format Cells -> Protection -> and tick Hide
Hi All
I do not see why that would be impossible.
Use a Sheet Specific Selection Change macro
use the macro to copy the formula in the cell into a string.
copy paste the value into the cell.
When another cell is selected or the sheet is changed or the workbook is closed
then enter the formula back into the cell.
That is the theory, I assume the practice will be harder.
My Rules if you want my help:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Unable to edit my original post.
Please Login or Register to view this content.
@ChipSlave - try it and see.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks