this code in VBA Generates popup excel and Closed Automatically . Here How can This make visible false

Set mchart1 = ActiveDocument.Shapes.AddChart(xl3DAreaStacked, , , shp1.Width, shp1.Height)

thanks

CodePudding user response：

Please, use the next code line:

mchart1.Chart.ChartData.Workbook.Application.Visible = False

But do you need them sometimes to be visible and do something with them?

If you iterate many times and your code creates many such Excel charts, your memory will be occupied with a lot of useless garbage...

If you will understand my concern, you can change the above solution in:

mchart1.Chart.ChartData.Workbook.Application.Quit