Hi, I have this code in my module
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.
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
This question generated 32 answers. To proceed to the answers, click here.
This thread is current as of June 07, 2015.