Buttons

[bobojimmye]

I'm trying to create a "button" that starts in red, turns green when clicked and reverts back to red at the beginning of a new week.... Can anyone help?

I now have just two buttons "stack" so when you click the top one it shuffles to the other.


thanks for reading; and I appreciate any help or suggestions.

 

[Micron]

Is it an ActiveX command button or a forms commandbutton? If the former, you can set its backcolor to red in design view then change it to vbgreen in the click event. As for flipping it back to red, you'll need a way to know that the week has advanced. That could be accomplished by comparing the current week value to a date in a sheet helper cell.