Check Box reference name
If you used a checkbox from the Forms toolbar, you'll be able to right click on
each and assign the same macro to each.
Kris in Kenya wrote:
When I create a checkbox in multiple worksheets within the same document,
excel assigns different references to it - this has as a consequence I can
not assign the same workbook macro's (it inetract with 3 macro's) to it as it
has another reference and I would have to write as many macro's as I have
worksheets (30!) while in fact the function is the same - I cannot find any
way to chanjge the excel assigned reference
--
Dave Peterson
|