Clear Form and Reset Toggles on Multiple Sheets

[Olivia Grant]

I am trying to reset/clear multiple sheets in an excel document as well as resetting the toggle buttons to "True".
I can get the information to clear from all sheets and the toggles to reset on the active sheet but can't get the toggles from the 2 others sheets to reset. My clear button is on the "Paid" Sheet. I get Run-time error '1004': Select method of Range class failed. When I debug, it takes me to where I initially created my toggle and highlights ".Select":

Private Sub ToggleButton1_Click()
With Rows("11:11")
.Select
.EntireRow.Hidden = Not .EntireRow.Hidden
End With
End Sub

Below is the macro attached to my clear form button and the lines giving me issues.

Private Sub CommandButton1_Click()
Sheets("Paid").Range("E10:E296").Value = ""
Sheets("Unpaid").Range("E10:E186").Value = ""
Sheets("Pending").Range("E10:E26").Value = ""
ActiveSheet.CommunityRelations.Value = True
ActiveSheet.Digital.Value = True
Sheets("Unpaid").ToggleButton1.Value= True

Sheets("Pending").ToggleButton1.Value= True

MsgBox "Form has been cleared."
End Sub


Thanks for any help you can give!

 

[Dendro]

you would have to tell excel where to find that row , so 'with rows("11:11")...select" becomes the below code. Also there is no need to select it.

With Sheets(name of sheet).Rows(11)
[I][SIZE=2][FONT=arial].EntireRow.Hidden = Not .EntireRow.Hidden[/FONT][/SIZE][/I]
[I][SIZE=2][FONT=arial]    End With[/FONT][/SIZE][/I]
[I][SIZE=2][FONT=arial]End Sub[/FONT][/SIZE][/I]

Now to do this with each sheet you would have to create a for each loop.

 

[Olivia Grant]

thank you Dendro!
I was able to rewrite the code for the toggles and they now reset correctly.

Appreciate the help.

 

[Dendro]

Great! Had the same problem a while ago, so easy to miss it.

good luck

 

[Olivia Grant]

When I email the spreadsheet to another computer the toggle buttons are no longer active. Any idea how to get them working again?