Dim i As LongIf Columns("A").SpecialCells(xlCellTypeVisible).Count = Rows.Count Then Exit Sub
i = 1
Do Until Rows(i).Hidden = True
i = i + 1
Loop
Rows(i).Hidden = False
'ActiveSheet.Protect
End Sub
Sub unhide()
Dim i As Long
For i = 6 To 43
Rows(i).Hidden = False
Next
'ActiveSheet.Protect
End Sub
Sub hide()
Dim i As Long
For i = 43 To 6 Step -1
Rows(i).Hidden = True
Next
'ActiveSheet.Protect
End Sub