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!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
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 General Rules if you want my help. Not aimed at any person in particular:
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