Hello gang

I'd appreciate any kind of help with this, I've tried all I could find on google and using the VBA help, with no success.

I'm using Excel 2007 and I created a bunch of ActiveX Controls, some buttons basically that are all similar in behaviour, they just call the same sub with different paramenters. Well, what I want to do when one of the buttons is pressed (besides calling the specific sub with its parameters) is make that particular button change its backcolor. No pb so far, easy thing to do. But I want one more thing - let's say the default color for them buttons is Green, and after I press it they turn Red. Well, I click button A and it turns Red as expected, but after that I press button B and I want it to turn Red while, at the same time, make all the other buttons turn to their defult color, i.e. green.

Anyone has any ideas about this? I've been trying to use ShapeRanges and alike, but I'm a complete rookie with that so no success.

Furthermore (one more complication ), not all buttons have the same default color. I have three sets of buttons - red ones, green ones and blue ones - and they all turn black when pressed. So what I want to do is make a button turn black when pressed, while at the same time making all the other buttons return to their original color (that way I can always tell which button was pressed last). I know I could use some workaournds, like display in a cell which button was pressed and so on and not worry about them darn colors, but that is my last option

Thanks for any kinda help!