There is probably some other way to do this, but I have 15 "shapes" that are buttons by means of attaching a macro to each, one for each team member.

It would be pretty lame to copy the same macro for each of the 15 buttons when the only thing that changes each time is a named range that gets copied for pasting later on in the macro.

If I could tell the code which shape-button was clicked I could then use something like a case statement (my personal memory has fragments of coding in it, it has been a while) so if button "shape01" was clicked, the named range is "PersonRange01" and so on.

Can this be done, or do I need to crank it up a notch and use a group of form buttons, or "worse"(?) yet, activeX controls? Is there an advantage as to one or the other in the event I do have a choice?

Thank-you!