unprotect the cells which you want the to be able to modify before you
protect the sheet

"Narendra Boga" wrote:

Thanq very much for your instant reply..

here the whole sheet is prected from the editing the sheet. I need to allow
edit to others such as entering the data into another rows and columns. The
only thing is the calculated formula shuld not visible to others. The
calculated formula is secreat to others. plese give suggestion.....

"Aivis" wrote:

Mark cells that contain formula, than use comand Format-Format Cells and
choose Protection tab. Tick in checkbox Hidden and close the box with OK.
After than protect sheet using Tool-Protect-Protect sheet (enter password).
After OK hidden cells will not show any result.

--
A.B.


"Narendra Boga" rakstîja:

Hi All.

Could you please tell, how to hide the formulas entere into a cell. That
should be invisible to others who are in shared network, but the result
should visible.

And that should be desplayed on other words instead of the formula.

for example:

A3 cell consists formula =a1+a2;
after entering the formula, in formula bar "=a1+a2" should not display
instead "sum" should display or the formula shold not disply.

please help me.

Narendra