using outlines in a protected sheet

[dbrown]

I have just created a model which has almost a thousand rows, I have used outlines to aid users navigation, but when i protect the sheet the outlines are disabled. It seems use of outlines are not an option under the protection tab.

Please is there a way I can protect the sheet and still use the outline buttons?

 

[Jon von der Heyden]

I use a macro, something to this effect:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    
    If ActiveCell.Activate = True Then
        If ActiveCell.Locked = True Then
            Range("A1").Select
            MsgBox ("Cell locked!")
        End If
    End If
End Sub

This requires cell A1 to be unlocked, you may want to change to a different range.

 

[dbrown]

Thanks it works great!