View Full Version : Solved: Control Chart Window
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!
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
08-22-2007, 09:25 AM
Unprotect the sheet first, do your stuff, and protect it again.
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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.