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

[jpbonono]

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.

 

[Fishboy]

But that does take a deliberate action rather than being accidental which is in certain circumstances is a reason for protecting a worksheet without a password a bit like a "are you sure you want to do this" button (I won't go into whether it is worth password protecting a sheet).

True, you make a very valid point, and from the standpoint of adding in another layer of required interaction before formulas can be tampered with this is worthy in and of itself.

Technically speaking however, it wouldn't prevent idle hands with curious minds from tinkering, and based on the level of concern that jpbonono has shown in his previous posts for keeping his formulas safe / private, a password does seem the logical course of action.

 

[MARK858]

based on the level of concern that jpbonono has shown in his previous posts for keeping his formulas safe / private, a password does seem the logical course of action.

Except that password protection in Excel is so weak that someone with only moderate knowledge can easily bypass it (darn it, I stated I won't go into whether it is worth password protecting a sheet yet still did )