macro > protect sheet settings

[bluepenink]

Hello

can someone help me add the "hide/unhide" options?

Private Sub Workbook_Open()
Application.ScreenUpdating = False
Dim ws As Worksheet
For c = 1 To Sheets.Count
               With Worksheets(c)
        .Protect Password:="analyst", AllowDeletingRows:=True, userinterfaceonly:=True
        .EnableOutlining = True
        End With
Next c

basically, i want to provide the user the ability to hide/unhide columns/rows when teh sheet is protected.

can someone pls help!

thx u!

 

[AlisonS]

When you set the sheet protection tick Format Columns and Format Rows - if you record this you'll get the syntax.

HTH.