Simon,
Try the protection function "in reverse". Select the columns in the entire
worksheet EXCEPT the column of formulas. Click on Format, Cells,
Protection. Uncheck the Locked option, and OK.

Then click on Tools, Protection, Protect Sheet, and OK.
This will put protection on just the formula column and the remainder of the
spreadsheet can be used. The formulas will still work, just cannot be
changed by users.

If formulas need to be changed, click on Tools, Protection, Unprotect Sheet.
BAE

"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.