Quote:
Originally Posted by macropod
It's not clear what you're trying to achieve with the Document_ContentControlOnExit macro. Do you intend to replace the content control with the chart, to insert the chart into the content control, or to insert the chart somewhere else?
|
I'm really open to any idea on achieving the end result, which is a way for the user to have a listing of all charts available and be able to insert a chart into the document. It does not have to be in a Content Control, but I think that is the current best approach to creating the listing of charts available? The macro would only need to run once to generate the listing.
I could possibly (still learning) accomplish with a user form to list all of the Chart Names (ie, column b), andthen have additional code to insert the chart link code (column C). But wouldn't that require to open and read the excel chart each time?