Making macros work in Excel 97

[Greg Determann]

This works in Excel 2000, but when a coworker tries to use some checkboxes that I set up, it gives her this:

Run-time error '1004'
Unable to set the HIdden property of the Range class


The code I have is this:

Private Sub CheckBox10_Click()
If CheckBox10.Value = True Then
Sheets("Projections").Range("A25").EntireRow.Hidden = False
Else
Sheets("Projections").Range("A25").EntireRow.Hidden = True
End If
End Sub

Any ideas why this isn't working and how to make it work. I know it is absolutely RIDICULOUS that she has Excel 97, but nothing we can do about it right now. Thanks in advance.

 

[Smitty]

Is the worksheet protected? That would cause that error, so maybe:

Private Sub CheckBox10_Click()
    If CheckBox10.Value = True Then
        With Sheets("Projections")
            .Unprotect
            .Range("A25").EntireRow.Hidden = False
            .Protect
        End With
    Else
        With Sheets("Projections")
            .Unprotect
            .Range("A25").EntireRow.Hidden = True
            .Protect
        End With
    End If
End Sub

HTH,

Smitty

 

[Greg Determann]

No, it is not protected. No idea why it is doing this.