Viewing protected cells
 

Is there a way to view LOCKED CELLS on a worksheet after the worksheet is
protected?
Could there be a macro created so that I can use for example ALT+L to view
these cells temporarely and then press ESC to go back to normal bview? This
could be in a temporary formatting of these cells in a different background
color.
This would be a very handy way to quickly make sure that the required cells
are locked when creating a worksheet with locked cells. There is another
way, which is using TAB to jump from one locked cell to another but it is
time consuming.
That function does not exist in Excel : TOOLS/Options/Window options.

Thank you
André

Andre

You can use a macro to color the locked cells, then reverse to remove the
color.

Sub Locked_Cells()
Dim Cell As Range, tempR As Range, rangeToCheck As Range
For Each Cell In Intersect(Selection, ActiveSheet.UsedRange)
If Cell.Locked Then
If tempR Is Nothing Then
Set tempR = Cell
Else
Set tempR = Union(tempR, Cell)
End If
End If
Next Cell
If tempR Is Nothing Then
MsgBox "There are no Locked cells " & _
"in the selected range."
End
End If
tempR.Interior.ColorIndex = 3
' tempR.Interior.ColorIndex = xlNone
End Sub


Gord Dibben Excel MVP

On Sat, 9 Apr 2005 12:59:28 -0400, "AC_VID" wrote:

Is there a way to view LOCKED CELLS on a worksheet after the worksheet is
protected?
Could there be a macro created so that I can use for example ALT+L to view
these cells temporarely and then press ESC to go back to normal bview? This
could be in a temporary formatting of these cells in a different background
color.
This would be a very handy way to quickly make sure that the required cells
are locked when creating a worksheet with locked cells. There is another
way, which is using TAB to jump from one locked cell to another but it is
time consuming.
That function does not exist in Excel : TOOLS/Options/Window options.

Thank you
André