Locking Formula - Whole Column

[Schwimms]

Hi,

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

 

[Rick Rothstein \(MVP - VB\)]

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]

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\)]

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