Yes, I misunderstood your reference to "lock" to mean "protection" rather
than "absolute references". If you can make use of a macro, the following
one will convert **all** range reference in the formulas within the cell in
the current selection to absolute references...

Sub SwitchToAbsoluteReferences()
Dim R As Range
For Each R In Selection
R.Formula = Application.ConvertFormula(R.Formula, xlA1, , xlAbsolute)
Next
End Sub

Just select the range of cells you want to convert (the column based on your
original posting) and run the macro.

Rick


"Schwimms" wrote in message
...
Sorry I must have phrased myself wrong. I do not want to protect the sheet
from entries I want the formulas to be locked. IE ; change (A1+B1) to
($A$1 +
$B$1). I just want all my formulas to be locked.

"Rick Rothstein (MVP - VB)" wrote:

I've never use this option before, but it looks like you can give
permission
to just yourself via the Tools/Protection/Allow Users To Edit Ranges item
on
Excel's menu bar.

Rick


"Schwimms" wrote in message
...
Hi,

I want to lock all the formulas in a whole column without having to go
into
each cell individually. Is this possible?