2 questions: Macro Mapping & Active Chart
 

I hope that someone can help. I have an Excel sheet with Buttons (each tied
to a Macro) that affects the Chart on the page.
The problem is that this will be massly distributed to numerous people, and
the people will likely copy & paste that tabs to their liking, which will
cause errors with the buttons & macros.

Herere are my 2 specific questions:
1. Is there a way to tie a BUTTON to a MACRO for the 'current active Excel
file'?
When assigning a MACRO, it kind-of hard-codes the current file name into
the assignment, which can cause issues.
2. How do I select the ACTIVE CHART on the ACTIVE WORKSHEET?
Currently, I have it set as: ActiveSheet.ChartObjects("Chart 1").Activate
However, it may not always be Chart 1. :-(

Thanks,
Mike