Build a generic function/sub that is called by the individual control subs,
then only need to change one.

Or use Forms controls, they can all assign the same macro.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ben" wrote in message
...
Is there a workaround to run the same code on multiple controls EMBEDDED
INTO
A WORKSHEET. I have the workaround for userforms but say for instance. I
have
about 120 Labels on a sheets, and when I click on any of them I want them
to
all run the exact same code, changing their background color???? Very
annoying to have 120 seperate codes, especially now that I need to change
each and every one to accomodate a new change. Help Please :P
Ben