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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide Formula & Allow Copy
While protecting your worksheet
ToolsProtection Protect Sheet (OR) After pressing press Alt+T+P+P You will get a protect sheet dialog box in that Under the heading €śAllow all Users of this Worksheet to:€ť CHECK the €śSelect Locked Cells€ť and €śSelect Unlocked cells€ť and UNCHECK all the remaining check boxes and give your desired password twice and give ok.. Now the users can able to see the cell values and they can able to copy the cell values only. Just select the cells for which you want to protect and do right clickFormat CellsProtectionTick Both Locked & Hidden Check boxes and give ok. By clicking locked will make the cell not accessible and by giving Hidden the Formulas which you have used cannot be viewed. Unlock all the cells which ever you want the people to have access as mentioned below: To unlock the cells Select the Columns Or Cells that needs to have the Editing option and do right clickFormat CellsProtectionUncheck Both the Locked & Hidden Check boxes and give ok. Now Protect the worksheet with a password ToolsProtection Click Protect Sheet OR press Alt+T+P+P and Provide your desired password Twice and give ok. Keep in mind that now the worksheet is getting protected and the locked cells cannot be accessed by the users unless the worksheet is Unprotected. To unprotect the worksheet place the cursor in Protected worksheet and select ToolsProtectionUnprotect sheet with your password and give ok. Or Alt+T+P+P and enter your password and give ok. -------------------- (Ms-Exl-Learner) -------------------- "MFS" wrote: 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 |
Reply |
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 |