Save "chart in microsoft word" as macro enabled file

[JennyLyons]

Hello!

I am working on a project where I am building charts in a Word file through the embedded Excel feature. Each chart in the Word file has its own mini Excel document. I found some code I was using on another project where, using VBA, it sets the chart axis min and max based on a cell value. I want this to happen in the embedded Excel documents in the Word file, but I cannot figure out how to make it happen. I saved the Word file as a macro-enabled document. I go into the embedded chart Excel file and add the VBA module and code. It works fine. The problem is when I exit, it does not seem to save the code in the mini Excel file. When I open it back up, the module is gone. My suspicion is that even though the main Word file is saved as macro-enabled, the mini backend Excel documents are not.

Can anyone help me solve this?

Thanks so much!

 

[Macropod]

Any code you use for this has to be saved in the Word document, not in the embedded object, and requires the object to be automated for use.