Okay I understand now.

You could hilight the whole sheet and then 'format
cells'....'protection'.... and uncheck the locked box.

Then hilgiht the areas of the sheet you do not want changed and once again
'format cells'....'protection' but this time click the 'locked' box.

Then go to 'tools'...'protection' and protect the sheet. Only the parts of
the sheet you highlighted and locked should now be unaccessable.

(Make sure you make a backup copy of your file before fiddling with
protecting and locking things.)

"SiH23" wrote:

Thanks for the reply Tim. Basically I want it so the values in the column
cannot be altered in anyway. This is why I was wondering as to whether it was
possible to 'lock' the column in some way.

Regards,

Simon.

"tim m" wrote:

Do you never ever want the numbers to be altered? You could copy the column
and then 'paste special'...'values' right on top of the existing column. You
will then have the actual numbers rather than the forumlas in the column.
(Of course if you wanted to retain the formulas you could insert a new column
and do the same thing.)

"SiH23" wrote:

Hi,

I have a column with a series of Sum functions. I don't wish the totals to
be altered, is there anyway that I can lock the column to prevent this.

Many thanks,

Simon.