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...
Bookmarks