Solved: Control Chart Window

[OdiN]

I'm trying to make a macro which will allow someone to click on a button for each chart in a sheet. It will open a chart window, and then resize that window to say 2 times as large. I can get the window open, but I can't figure out how to resize that window, if it's possible.

Any help would be appreciated. Thanks!

[OdiN]

Also this needs to work with a locked chart on a protected sheet...which I'm finding out it isn't working so well.

[Bob Phillips]

Unprotect the sheet first, do your stuff, and protect it again.

[OdiN]

Unprotect the sheet first, do your stuff, and protect it again.
Yes I am aware of how to do that. However, when protecting the sheet again, it closes the chart window.

I am going to use a different method which should work. Controlling the chart window doesn't seem possible.