application development excel - Protecting a cell?

Hi Steve,

To protect a cell in an Excel worksheet, use the Tools > Protection> Protect Sheet menu option. Worksheet protection will affect /apply only to "Locked" cells, and by default Excel cells are locked. A password can be enabled to restrict user access.

To unlock an Excel cell or range of cells, select the cell(s), click on the Format > Cells menu and select the Protection tab sheet. Untick the Locked option. Please also note that to not display the contents of cells in the formula, such as a Sum function, tick Hidden.

Where you state, ..."prevent other user seeing what the sum is", I understand that to mean the sum formula in the formula bar.

Hope this helps