Most valuable professional
  • Hot Topics

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

Hi, I have this code in my module Code: Private Sub Boys_Click()If Boys.Value = 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 7, 2015.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel