I’ve set all fonts to be black. Then I made conditional
formatting on all cells with this:
In order to make all cells that are not locked have blue fonts.
Then I put this code in sheet1:
It seemed to work fine at first but I soon found out that it’s very
“unstable”. It’s like some cells get locked at random… or not
locked. I don’t quite know how to put it but it’s very unpredictable.
Maybe it’s some Range “stuff”?
I'm using Excel 2003 and Windows XP
formatting on all cells with this:
Code:
=CELL(“protect”;A1)=0
In order to make all cells that are not locked have blue fonts.
Then I put this code in sheet1:
Code:
Public Sub LockUsedRange()
Cells.Select
Selection.Locked = False
Selection.FormulaHidden = False
ActiveSheet.UsedRange.Locked = True
Range("A1").Select ‘just for now to “unselect” all the cells.
End Sub
It seemed to work fine at first but I soon found out that it’s very
“unstable”. It’s like some cells get locked at random… or not
locked. I don’t quite know how to put it but it’s very unpredictable.
Maybe it’s some Range “stuff”?
I'm using Excel 2003 and Windows XP