Locking some cells and hiding formula
 

I have made some calculation for material planning. I want to hide the
formulas and at the same time i want to lock the cells where i get output,
but i don't want to lock the cells where I input the data.
This i want when i give it to someone else.

Locking some cells and hiding formula
 

two steps:

1) For the cells where you want to lock and hide the formula
Do Format Cells Protection choose locked and hidden
For other cells where you will input data, which will not be locked, choose
unlocked and unhidden

2) do tools protect worksheet. choose the actions you want the user to be
able to do.

--
Allllen


"parag" wrote:

I have made some calculation for material planning. I want to hide the
formulas and at the same time i want to lock the cells where i get output,
but i don't want to lock the cells where I input the data.
This i want when i give it to someone else.