Hi

You have to set for all cells you want formula not to be visible the Hidden
property to True (check Hidden checkbox on Protection tab of Format Cells
window). In same place you also can set cell conents to be locked/unlocked
(user can't change contents of locked cell) - by default all cells are
locked.

Cell protection settings will be working only, when the sheet is protected.
I.e. set protection settings as you need, and after that protect the sheet
(with password or without as you like).


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"Riya" wrote in message
...
Hai,
When a formula is given to the cell for calculation, that formula must be
hidden. But, the calculation must be done.