Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Check the attachment, i have used the macro to resore the minimized object which is in Main Sheet.
- Sridhar
Hi,
Check the attachment, i have used the macro to resore the minimized object which is in Main Sheet.
- Sridhar
Thank you, Sridhar. It works absolutely great!