Hide formula

[atuljadhav]

i have formula in in C1 formula is sum(A1:B1)
and this cell (C1) is locked
but i dont't want that the user can see this formula or can select locked cell
only he has right to add the value in A1 & B1

pl revert

 

[VoG]

Select C1, press CTRL + 1, on the protection tab tick Locked and Hidden and click OK. Then protect the worksheet.

 

[atuljadhav]

but still i can select the cell
user must not select this cell

 

[VoG]

When you protect the sheet, untick the option that allows users to select locked cells.

 

[atuljadhav]

tnx its working
but i have locked whole C column and i have paste formula till C6,
is there any function that if i insert the row after 4the row than the formula automaticaly paste in C5, even after the cell is locked and user having right to insert the row
Using Excel 2003

 

[atuljadhav]

please revert