Safety in Cells

Hi chojje,

To stop someone changing a cell you need to protect the sheet - all cells are protected by default when you protect the sheet so before doing this you need to select the cells that may be changed, right click >format > protection > remove the check mark against locked.

Then go to tools > protection > protect.

Not quite sure what you mean by the second part but if the problem you want to cure is that if the result of a calculation is negative then

=If(Your_calc<0,0,Your_calc)

Let me know how you get on

Ed

Originally Posted by EdMac

Hi chojje,

To stop someone changing a cell you need to protect the sheet - all cells are protected by default when you protect the sheet so before doing this you need to select the cells that may be changed, right click >format > protection > remove the check mark against locked.

Then go to tools > protection > protect.

Not quite sure what you mean by the second part but if the problem you want to cure is that if the result of a calculation is negative then

=If(Your_calc<0,0,Your_calc)

Let me know how you get on

Ed

The protection you are talking about concerns me/anyone being able to change for example a number in a certain cell. What i mean is that if a cell INCLUDES a Function (ex: IF(A1<1,1,0)) in anyway i dont want anyone to be able to change it.
Do u understand?

The other part worked thanks

If it is protected then it does not matter what the contents are - they are protected.

On the sheet protection menu, you can select what users can do.

Try it out and see if it works

Ed

Originally Posted by EdMac

If it is protected then it does not matter what the contents are - they are protected.

On the sheet protection menu, you can select what users can do.

Try it out and see if it works

Ed

Now, i happened to set the lock at a different sheet :P But now it works thanks mate