If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Hide Formula
I would like to know how to hide the formula & when a user copies the cell
get only the result (just like what past special does). -- MFS22 |
#2
|
|||
|
|||
Hide Formula
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 Formula’s 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. Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "MFS" wrote: I would like to know how to hide the formula & when a user copies the cell get only the result (just like what past special does). -- MFS22 |
#3
|
|||
|
|||
Hide Formula
(I went there before) See, when I protect the sheet a user can see the result
(of the formula) but can't copy it because it is protected , 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 view the result of the formula & copy the result, only the result without the formula. I appreciate your support. -- MFS22 "Ms-Exl-Learner" wrote: 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 Formula’s 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. Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "MFS" wrote: I would like to know how to hide the formula & when a user copies the cell get only the result (just like what past special does). -- MFS22 |
#4
|
|||
|
|||
Hide Formula
A possible solution:
Set the cell up as Ms-Exl-Learner suggests lets say A1 then before preotecting the sheet in say B1 enter the formula =A1. Make sure B1 has protection removed. Format the font in A1 the same colour as the cell background to hide the contents. Now protect the sheet Your user can now see the results of the calculation, copy it and only see the calculation as =A1 Hope this helps "MFS" wrote: (I went there before) See, when I protect the sheet a user can see the result (of the formula) but can't copy it because it is protected , 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 view the result of the formula & copy the result, only the result without the formula. I appreciate your support. -- MFS22 "Ms-Exl-Learner" wrote: 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 Formula’s 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. Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "MFS" wrote: I would like to know how to hide the formula & when a user copies the cell get only the result (just like what past special does). -- MFS22 |
#5
|
|||
|
|||
Hide Formula
You people are mind reader , I’m using this method but still I want the
user to have the result 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? -- MFS22 "Ron@Buy" wrote: A possible solution: Set the cell up as Ms-Exl-Learner suggests lets say A1 then before preotecting the sheet in say B1 enter the formula =A1. Make sure B1 has protection removed. Format the font in A1 the same colour as the cell background to hide the contents. Now protect the sheet Your user can now see the results of the calculation, copy it and only see the calculation as =A1 Hope this helps "MFS" wrote: (I went there before) See, when I protect the sheet a user can see the result (of the formula) but can't copy it because it is protected , 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 view the result of the formula & copy the result, only the result without the formula. I appreciate your support. -- MFS22 "Ms-Exl-Learner" wrote: 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 Formula’s 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. Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "MFS" wrote: I would like to know how to hide the formula & when a user copies the cell get only the result (just like what past special does). -- MFS22 |
#6
|
|||
|
|||
Hide Formula
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. -------------------- (Ms-Exl-Learner) -------------------- "MFS" wrote: You people are mind reader , I’m using this method but still I want the user to have the result 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? -- MFS22 "Ron@Buy" wrote: A possible solution: Set the cell up as Ms-Exl-Learner suggests lets say A1 then before preotecting the sheet in say B1 enter the formula =A1. Make sure B1 has protection removed. Format the font in A1 the same colour as the cell background to hide the contents. Now protect the sheet Your user can now see the results of the calculation, copy it and only see the calculation as =A1 Hope this helps "MFS" wrote: (I went there before) See, when I protect the sheet a user can see the result (of the formula) but can't copy it because it is protected , 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 view the result of the formula & copy the result, only the result without the formula. I appreciate your support. -- MFS22 "Ms-Exl-Learner" wrote: 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 Formula’s 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. Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "MFS" wrote: I would like to know how to hide the formula & when a user copies the cell get only the result (just like what past special does). -- MFS22 |
#7
|
|||
|
|||
Hide Formula
Now it works, thanks a loooooot Ms-Exl-Learner, thank you for your Patience &
support, what a great mother you will be -- MFS22 "Ms-Exl-Learner" wrote: 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. -------------------- (Ms-Exl-Learner) -------------------- "MFS" wrote: You people are mind reader , I’m using this method but still I want the user to have the result 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? -- MFS22 "Ron@Buy" wrote: A possible solution: Set the cell up as Ms-Exl-Learner suggests lets say A1 then before preotecting the sheet in say B1 enter the formula =A1. Make sure B1 has protection removed. Format the font in A1 the same colour as the cell background to hide the contents. Now protect the sheet Your user can now see the results of the calculation, copy it and only see the calculation as =A1 Hope this helps "MFS" wrote: (I went there before) See, when I protect the sheet a user can see the result (of the formula) but can't copy it because it is protected , 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 view the result of the formula & copy the result, only the result without the formula. I appreciate your support. -- MFS22 "Ms-Exl-Learner" wrote: 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 Formula’s 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. Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "MFS" wrote: I would like to know how to hide the formula & when a user copies the cell get only the result (just like what past special does). -- MFS22 |
#8
|
|||
|
|||
Hide Formula
You are welcome and thanks for feeding back.
-------------------- (Ms-Exl-Learner) -------------------- "MFS" wrote: Now it works, thanks a loooooot Ms-Exl-Learner, thank you for your Patience & support, what a great mother you will be -- MFS22 "Ms-Exl-Learner" wrote: 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. -------------------- (Ms-Exl-Learner) -------------------- "MFS" wrote: You people are mind reader , I’m using this method but still I want the user to have the result 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? -- MFS22 "Ron@Buy" wrote: A possible solution: Set the cell up as Ms-Exl-Learner suggests lets say A1 then before preotecting the sheet in say B1 enter the formula =A1. Make sure B1 has protection removed. Format the font in A1 the same colour as the cell background to hide the contents. Now protect the sheet Your user can now see the results of the calculation, copy it and only see the calculation as =A1 Hope this helps "MFS" wrote: (I went there before) See, when I protect the sheet a user can see the result (of the formula) but can't copy it because it is protected , 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 view the result of the formula & copy the result, only the result without the formula. I appreciate your support. -- MFS22 "Ms-Exl-Learner" wrote: 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 Formula’s 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. Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "MFS" wrote: I would like to know how to hide the formula & when a user copies the cell get only the result (just like what past special does). -- MFS22 |
Thread Tools | |
Display Modes | |
|
|