whats wrong with vba code keep getting error message

[aedctalk]

I'm trying to hide hide and unhide a row on another sheet "FRI" my checkboxes are on sheet "CONFIG" if i take out the top 2 lines my code hides on the active sheet just fine..

However when trying to hide on sheet "FRI" with top 2 rows in i get.

UNABLE TO GET CHECKBOXES PROPERTY OF WORKSHEET CLASS....

How exactly can i make these rows hide correctly on another sheet? whats wrong Thank you

Sheets("FRI").Select
Sheets("FRI").Activate
ActiveSheet.Unprotect
Dim cb As Excel.CheckBox

Set cb = Excel.ActiveSheet.CheckBoxes(Application.Caller)
If cb.Value = xlOn Then
Rows("80:88").EntireRow.Hidden = False
Else
Rows("80:88").EntireRow.Hidden = True
End If
ActiveSheet.Protect

End Sub

 

[doofusboy]

Perhaps you could try something like this:

[COLOR=red][B]Sheets("FRI").Unprotect
[/B][/COLOR]
Dim cb As Excel.CheckBox

Set cb = Excel.ActiveSheet.CheckBoxes(Application.Caller)
If cb.Value = xlOn Then
[COLOR=red][B]Sheets("FRI").[/B][/COLOR]Rows("80:88").EntireRow.Hidden = False
Else
[COLOR=red][B]Sheets("FRI").[/B][/COLOR]Rows("80:88").EntireRow.Hidden = True
End If
[B][COLOR=red]Sheets("FRI").Protect
[/COLOR][/B]
End Sub