Run VBA on Protected worksheet

Hi

I am having a similar problem to Bob@sun.

I am new at VBA's and can't figure out how to incorporate the 'Userinterfaceonly" part into my code

Basically:
- I want If column 3 (i.e. c) is zero, then I want to hide rows 44-57 , 66-69, and 91 - 104
- This works until i protect the worksheet
- I have tried to incorporate 'ActiveSheet.Unprotect Passsword: ='Secret' and ActiveSheet.Unprotect Password:="Secret" but can't subsequently unprotect my worksheet

How can I run VBA in a protected worksheet without it subsequently being all protected?

this is my code:

Sub HURows()
ActiveSheet.Unprotect Password:="Secret"
    BeginRow = 44
    EndRow = 57
    ChkCol = 3

    For RowCnt = BeginRow To EndRow
        If Cells(RowCnt, ChkCol).Value = 0 Then
            Cells(RowCnt, ChkCol).EntireRow.Hidden = True
        Else
            Cells(RowCnt, ChkCol).EntireRow.Hidden = False
        End If

    Next RowCnt

    BeginRow = 66
    EndRow = 79
    ChkCol = 3

    For RowCnt = BeginRow To EndRow
        If Cells(RowCnt, ChkCol).Value = 0 Then
            Cells(RowCnt, ChkCol).EntireRow.Hidden = True
        Else
            Cells(RowCnt, ChkCol).EntireRow.Hidden = False
        End If
    Next RowCnt

    BeginRow = 91
    EndRow = 104
    ChkCol = 3

    For RowCnt = BeginRow To EndRow
        If Cells(RowCnt, ChkCol).Value = 0 Then
            Cells(RowCnt, ChkCol).EntireRow.Hidden = True
        Else
            Cells(RowCnt, ChkCol).EntireRow.Hidden = False
        End If
    Next RowCnt

    ActiveSheet.Unprotect Password:="Secret"
End Sub

Any help with telling me how my code should be is much appreciated!!

thanks

The UserInterfaceOnly flag has to be turned on each time the sheet is opened and/or unlocked and relocked. That particular parameter does not survive the closing of the workbook... dumb, but that's how it is.

So, you're code will work as is, it appears you are using the more common technique of simply unprotecting, doing your stuff, and then protecting again. That works, and it introduces no headaches like UserInterfaceOnly can do if it gets turned off somehow and all your macros stop working. Is it really worth the effort?


BTW, don't forget CODE tags, I've added them to the post above, you'll need to do that from now on, OK?

ah - sorry, will do CODE tags from now on.

Also my code up there says 'unprotect' on the second last line, it actually says 'protect' (otherwise i get the code error '400')

So everything stays protected after run it, how do I unprotect it?

Originally Posted by Dukes

....how do I unprotect it?

By taking that line completely out.