Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide Formula & Allow Copy
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 didnt find anything (or I missed) in the promotions 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 dont 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 dont have the promotion to see the sheets formulas still I can copy the result without any access to the formula. So it is possible, but how? I appreciate your support. -- MFS22 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect individual cell and hide formula in formula bar | Excel Worksheet Functions | |||
formula to hide row | Excel Worksheet Functions | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
Hide Rows - copy and paste only rows that show | Excel Worksheet Functions | |||
how to hide the formula | Excel Worksheet Functions |