Hi, this is my macro i am having a problem when I put the funtions for the unprotect and protect in my macro....I think I al writing them in the wrong place.....

Protect CODE
ActiveSheet.Unprotect "CVZ"
ActiveSheet.Protect "CVZ"

-------------------This is my Macro that works well


Option Explicit

Private Sub CommandButton1_Click()
Dim x As Range
Dim y As Range
Set y = Range("A7:A371")
Application.ScreenUpdating = False

For Each x In y
If x.Value = "" Then
x.EntireRow.Hidden = True
End If
Next x

Application.ScreenUpdating = True
End Sub

Private Sub CommandButton2_Click()
Cells.EntireRow.Hidden = False
End Sub


THANKS FOR ANY HELP...