Button Appearence

A

Asif

I've created three toggle buttons that run an applyfilter macro. When
I click on button_1 the records are filtered as they should be but
when I click on Button_2 although the records are filtered accordingly
button_1 still stays depressed. Is there anyway of changing this so
that only the active macro is depressed and not the others

Many Thanks
 
S

storrboy

If they are part of an option group they will do so automatically.
Otherwise, you need to explicitly set each of them to True/False
depending on which was clicked - False being not depressed.
 
A

Asif

If they are part of an option group they will do so automatically.
Otherwise, you need to explicitly set each of them to True/False
depending on which was clicked - False being not depressed.
Click to expand...

how do i go about doing that, do i have to write some vba code if so
what as i'm not very good in that area
 
Top