2 Replies Latest reply: May 7, 2009 3:09 PM by banciu RSS

    Button to maximize a chart


      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,