This content has been marked as final. Show 2 replies
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?