Locking Formula - Whole Column

S

Schwimms

Hi,

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

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
 
S

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

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
 
Top