M
MFS
Hi,
I would like to know how to hide the formula & allow to users to copy the
cell & get only the result (just like what past special does).
I have tried “Protect Sheetâ€, when I protect the sheet a user can see the
result (of the formula) but can't copy it because it is protected
I didn’t find anything (or I missed) in the promotion’s list that allows
users to copy or copy the result.
When I remove the protection the user will have access on the formula (which
I don’t want to).
In short, I want the user to see the result of the formula & have the
promotion to copy the result, only the result without the formula so he can
work with if he needs.
I got an Email with Excel sheet which calculates your age & have some other
interesting functions, I don’t have the promotion to see the sheet’s formulas
still I can copy the result without any access to the formula. So it is
possible, but how?
I appreciate your support.
I would like to know how to hide the formula & allow to users to copy the
cell & get only the result (just like what past special does).
I have tried “Protect Sheetâ€, when I protect the sheet a user can see the
result (of the formula) but can't copy it because it is protected
I didn’t find anything (or I missed) in the promotion’s list that allows
users to copy or copy the result.
When I remove the protection the user will have access on the formula (which
I don’t want to).
In short, I want the user to see the result of the formula & have the
promotion to copy the result, only the result without the formula so he can
work with if he needs.
I got an Email with Excel sheet which calculates your age & have some other
interesting functions, I don’t have the promotion to see the sheet’s formulas
still I can copy the result without any access to the formula. So it is
possible, but how?
I appreciate your support.