locking specific cells that are hidden/shown based on VBA

[Excell-ent]

Hello!
I am completely new to VBA, however am trying to learn as much as possible and could really do with some help here!

I am having trouble with my VBA code, it hides groups of rows (projects) based on the contents of corresponding cells above. these have either 'yes' or 'no' in them (indicating if the person is active in that project). The Yes/No is formula based from another sheet.

what I am trying to do, is have particular cells, withing the projects rows, locked (as they are also populated by formulas) but have other cells open for editing.

when I try and do this i get an error with my VBA, i am assuming that as cells are locked, the VBA is prohibited form hiding inactive projects/rows.
i tried an addition at the bottom but this hasn't worked

Sub Worksheet_Calculate()
    Dim i As Long, StartRow As Long, EndRow As Long

StartRow = 13
EndRow = 29

For i = 6 To 11
    If UCase(Range("C" & i).Value) = "NO" Then
        Rows(StartRow & ":" & EndRow).EntireRow.Hidden = True
    Else
        Rows(StartRow & ":" & EndRow).EntireRow.Hidden = False
    End If
    StartRow = StartRow + 18
    EndRow = EndRow + 18
    Next i

End Sub

Private Sub Workbook_Open()
Sheets("Sheet1").Protect Password:="password", UserInterFaceOnly:=True
End Sub

 

[Drrellik]

Hello and welcome to the Forum. I am not well versed in the way of the VBA either.... but I do know that when you protect a sheet using ALT+T,P,P that you are then unable to accomplish a wide number of things to the sheet even to the unprotected cells. because the entire sheet is locked. hopefully someone else can weigh in on your Code. again welcome to the board.