Excel: [vba] cannot hide/unhide rows when sheet is protected


Hi, I have this code in my module

Private Sub Boys_Click()If Boys.Value = True Then
Rows("13:57").EntireRow.Hidden = True
Else
 Rows("13:57").EntireRow.Hidden = False
  End If
End Sub
However, my problem is whenever i protect the sheet it doesnt allow me to proceed(debug mode) since i am fully aware that some cells on the rows are protected to. (I already tried modified the default cell locking(allowing rows) and still wont work) Are there any work arounds here that would let excel allow the hiding/unhiding feature? Thank you in advance.


This question generated 32 answers. To proceed to the answers, click here.

This thread is current as of June 07, 2015.


For more resources for Microsoft Excel