Button to maximize a chart

[#1]

Maybe someone can help me with a macro that does the following thing: when you click on a button (that is located, let's assume, in a sheet called "index"), it should take you to the sheet where the object is in and also to maximize that particular object.

For example, I have a chart named "Sales per year" which is located in the "Sales reports" sheet. When I click on the button with the same named ("Sales per year") which is located in the sheet "Index", I want to activate the sheet named "Sales reports" and also to maximize the chart "Sales per year". Is it possible to do this with a macro?

Thank you,

Banciu

[#2 · Accepted solution]

Hi,

Check the attachment, i have used the macro to resore the minimized object which is in Main Sheet.

- Sridhar

[#3]

Thank you, Sridhar. It works absolutely great!