>...Trying to setup a macro that will color cells based on their locked/unlocked status. Making it up didn't quite work. Please help
![]()
Sub LockTest() For Each xCell In ActiveWorkbook.Worksheets If xCell.Locked = False Then xCell.ColorIndex = 37 End If Next xCell End Sub
Bookmarks