Here’s a utility to format unlocked cells using conditional formatting so that I can easily see that I’ve set the Locked property appropriately.
Private msFormula As String Sub ToggleLockedCellFormat()
Dim sh As Worksheet
Dim rng As Range
Dim fc As FormatCondition
Dim lFcIndex As Long
Set sh = [...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2010/06/15/show-locked-cells/
Posted
Jun 15 2010, 07:00 AM
by
Daily Dose of Excel