using outlines in a protected sheet

dbrown · Mar 17, 2006

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 · Mar 17, 2006

I use a macro, something to this effect:

Code:

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 · Mar 17, 2006

Thanks it works great!

using outlines in a protected sheet

dbrown

New Member

Jon von der Heyden

MrExcel MVP, Moderator

dbrown

New Member

Similar threads

Share this page

using outlines in a protected sheet

dbrown

New Member

Jon von der Heyden

MrExcel MVP, Moderator

dbrown

New Member

Similar threads

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock