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.

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