Button Appearence

  • Thread starter Thread starter Asif
  • Start date Start date
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
 
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.
 
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
 
Back
Top