I am using shapes with assigned macros as the selectors for my Sumproduct
criteria. So I have rectangle shapes with each person's name on them and
when I click on them they name is input into a criteria field on another
page. It works well, but is there any way to have the shape highlight or
change looks once I click on it so you can see which criteria has been
selected?

Thanks!