Want to unhide hidden rows while sheet is locked

[ddub25]

I have locked my worksheet to protect formulas, but also want the option of being able to hide and unhide rows while locked (I have grouped various rows so that I can toggle hiding and unhiding of these rows). Is there a way of being able to do this without having to unlock the sheet all the time?

Dan

 

[jai9]

Hi,

Are you looking for something like this?

Sub Test()

ActiveSheet.Unprotect Password:="abc"

If Rows("20:20").EntireRow.Hidden = True Then
    Rows("20:20").EntireRow.Hidden = False
    ActiveSheet.Protect Password:="abc"
    Exit Sub
ElseIf Rows("20:20").EntireRow.Hidden = False Then
    Rows("20:20").EntireRow.Hidden = True
    ActiveSheet.Protect Password:="abc"
End If

End Sub

Jai

 

[ddub25]

What does this code do? Does it temporarily unlock the sheet so that it can unhide the rows if they are hidden or hide the rows if thy are already unhidden? How would I implement it, would it need to be linked to a toggle button to do this? If that is what the code would do, and that is what needs to be done to solve my problem, then that would be very useful.

 

[ddub25]

I've just tried the code, but cannot work out how to test run it without having to create a button to activate it. Is there a way of manually running code to test it?