Button to Jump from Chart to Worksheet

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

Using a tip from this group we created an index worksheet
that creates quasi-hyperlinks to charts in the workbook.

Is there a way to jump from a chart worksheet back to the
index worksheet? We couldn't find a way to add some kind
of button or text box on the chart to accomplish this.

TIA.
 
You can add a button from the Forms toolbar, and assign a macro that
activates the index worksheet.
 
I tried that but must be doing something wrong. When I
open the control toolbox and activate a chart worksheet,
that option is "grayed out".

How can I get it to work?
 
Never mind. I got it.
I was trying to use the control toolbox instead of the
forms tollbox.
Thanks for the tip.
 
Works fine for me, do you have a macro that activates the index sheet?
If so, just grab a button from the FORMS toolbar and drag it to the sheet,
when you release the mouse you will be asked to assign a macro, just select
the macro,
maybe edit the button caption and go.. Don't know what you are doing with
the
control toolbox?

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
Back
Top