Reset All Toggle Buttons

[Ash_]

Hey Guys

Done a general search and tried a few ways, however I have been unable to find exactly what I need. I have a user form with TOGGLE buttons Mar 14, Apr 14 etc...

Mar 14 button has this vba code:

Please Login or Register  to view this content.

This hides columns when toggled ON, then shows them again when toggled OFF.

What I would like, is say I have 4 toggle buttons on a ON state, I would like a regular command button called "RESET ALL" which will set the state of all toggle buttons in my userform to OFF.

Is this possible?

Kind regards and many thanks in advance!

Ash

[nathansav]

Please Login or Register  to view this content.

[Ash_]

Worked an absolute treat, thanks alot!!!!

[Ash_]

Ohh one more question, is there a way that I can have that code automatically run when I change tabs? Ive tried the Worksheet active function but to no avail Thanks

[nathansav]

In thisworkbook

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)

End Sub

[Ash_]

Doesnt seem to work, it just stays the same when I flick through tabs.

[nathansav]

Is the code in the user forms?

[Ash_]

Yes, and I have also tried it in the general Workbook code aswell

In every Microsoft Excel Objects > Sheet(1/2/3)

I have MyUserFormName.Show so that everytime I change, it opens it up again.

I have tried MyUserFormName.Hide and .Show but that doesnt work either

[nathansav]

sorry


Private Sub Workbook_SheetActivate(ByVal Sh As Object)

[Ash_]

Do appriciate your help!

Every time I change tabs now, I get an Compile Rror: Method or data member not found.

Cheers for all your help so far by the way!

EDIT: Sorted it, changed me.controls to MyFormName.controls

Thank you so much for your help!

[nathansav]

no probs, glad to share the knowledge :o)