Tony,

I assume you understand that being 'Locked' doesn't mean they are protected.
All cells by default are locked but that only becomes active after you
protect the sheet.

To hightlight locked cells then you would need code. Right click your sheet
tab, view code and paste the code below in and run it
.. To remove the highlighting simply slect all cells and remove the fill
colour on the toolbar.

Sub Sonic()
For Each c In ActiveSheet.UsedRange
If c.Locked = True Then c.Interior.ColorIndex = 3
Next
End Sub

"Tony" wrote:

Can you highlight locked cells in excell, so you can check you have locked
the right ones, and after checking turn the highlight off