Thread: How can I maximize a chart since VBA 2007 has no sizewithwindow function anymore?

A macro opens a chart:

Sub ActivateChart()
        Sheets("NameOfChart").Select
End Sub

My goal is to maximize the width and height of the chart to fit exactly in every user window.
I understand that VBA in Excel 2003 had a sizewithwindow property, but VBA in Excel 2007 not.
Zooming the chart seems a solution, but I can't figure out how to do it.

Thanks for suggesting some hints!

Thanks Teylyn,

I placed my chart in its own chart sheet. Indeed, the resizing is automatically done. I did not mentioned that the aspect ratio of my chart stays the same.
So, a chart made to fit on a 4:3-screen is not filling a 16:9-screen.
I would like my chart to fit exactly on every kind of screen (no matter what the aspect ratio is).

Any ideas?