Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Issue with dynamic chart mapping out blank info | Excel Worksheet Functions | |||
Macro to copy columns from 1st sheet to 2nd according to mapping-p | Excel Programming | |||
Mapping macro | Excel Programming | |||
Chart Questions | Excel Programming | |||
Mapping a drive through a macro | Excel Programming |