Hai,
When a formula is given to the cell for calculation, that formula must be
hidden. But, the calculation must be done.

Format / Cells / Protection / Hidden

(or likewise - i don't have acess to the english version of excel....)




"Riya" skrev i melding
...
Hai,
When a formula is given to the cell for calculation, that formula must be
hidden. But, the calculation must be done.

highlight the whole row or column and right clickhide,or format the cell to
have white text (or whatever the backgrounf colour of that cell is)It may
baffle you or someone else in the future though!
--
paul

remove nospam for email addy!



"kk" wrote:

Format / Cells / Protection / Hidden

(or likewise - i don't have acess to the english version of excel....)




"Riya" skrev i melding
...
Hai,
When a formula is given to the cell for calculation, that formula must be
hidden. But, the calculation must be done.

Hi Paul,

Hiding the column/row hides both the formula and the result!!
Formatting the text to the same colour as the background doesn't hide the
formula either; only the result!!

The OP wanted to see the result, not the formula ... which is what kk's
solution provides.

Cheers


"paul" wrote in message
...
highlight the whole row or column and right clickhide,or format the cell
to
have white text (or whatever the backgrounf colour of that cell is)It may
baffle you or someone else in the future though!
--
paul

remove nospam for email addy!



"kk" wrote:

Format / Cells / Protection / Hidden

(or likewise - i don't have acess to the english version of excel....)




"Riya" skrev i melding
...
Hai,
When a formula is given to the cell for calculation, that formula must
be
hidden. But, the calculation must be done.

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.