Quote Originally Posted by nischalshety View Post
Hi Paul,
This may be outdated but just came across your solution for toggle buttons in ribbon. while it works for 2 buttons i would like it to work for 3 buttons i.e. one of the 3 button should be in pressed state. I am not a pro at vba but i tried to copy the code as in the attached file but does not work. Can you help me make it work please. I am using excel 2007.
basically i want one toggle button to choose either one of the three currencies i.e. USD, EURO, GBP
I have to use toggle button as i believe we cannot use option (radio) button in excel 2007 ribbon, which i would have loved to use instead.
I have a query that uses those same 3 currency options; I use a dropdown.