How can I add a control to an Excel chart?
I have an Excel workbook with a chart to show the trend of some data. The
data is generated on an hourly basis and I have written a macro which reads
new data into the workbook. At the moment I have a button on the toolbar
which calls the macro - but that button is always on the toolbar and I only
want to see it when I am looking at my data (after all - the macro is only
present in the one workbook). How can I embed a control in the chart so that
I only see it in this specific application?
|