link to sheets tabs

I have a list of 100 company names in a sheet called: Names
In other sheets (not 100 sheets but about 30 sheets) I draw a graph of daily
price for those companies. Graphes are stored as sheet not as object and
there is only graph with no data cells
I want to create a link in my main sheet (Names) so if I click it, Excel
goes to that companie's sheet.
I know how to create a link between a cell and another sheet but
unfortunately those sheets with graphs don't appear in link window box. Is
it possible?
TIA Rasoul Khoshravan

You can't hyperlink to the chart sheet, but Jon Peltier has a macro
workaround in his Charting FAQ article:

http://pubs.logicalexpressions.com/P...?ID=209#jon016

that you may be able to use.


Rasoul Khoshravan Azar wrote:
> I have a list of 100 company names in a sheet called: Names
> In other sheets (not 100 sheets but about 30 sheets) I draw a graph of daily
> price for those companies. Graphes are stored as sheet not as object and
> there is only graph with no data cells
> I want to create a link in my main sheet (Names) so if I click it, Excel
> goes to that companie's sheet.
> I know how to create a link between a cell and another sheet but
> unfortunately those sheets with graphs don't appear in link window box. Is
> it possible?
> TIA Rasoul Khoshravan
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Dear Debra
Thanks for your comments. Although I don't understamd VBA so much but I
copied the entire code of Jon Peltier to the view code of the tab (by right
clicking) and correct the sell reference from B2 to I182 of mine then I
saved and exited ther VBA editor but it didnt work. I am wondering if I am
missing a step or doing something wrong.
Your comments will be hilghy appreciated. TIA Rasoul Khoshravan


"Debra Dalgleish" <dsd@contexturesXSPAM.com> wrote in message
news:41E44E07.40708@contexturesXSPAM.com...
> You can't hyperlink to the chart sheet, but Jon Peltier has a macro
> workaround in his Charting FAQ article:
>
> http://pubs.logicalexpressions.com/P...?ID=209#jon016
>
> that you may be able to use.
>
>
> Rasoul Khoshravan Azar wrote:
> > I have a list of 100 company names in a sheet called: Names
> > In other sheets (not 100 sheets but about 30 sheets) I draw a graph of
daily
> > price for those companies. Graphes are stored as sheet not as object and
> > there is only graph with no data cells
> > I want to create a link in my main sheet (Names) so if I click it, Excel
> > goes to that companie's sheet.
> > I know how to create a link between a cell and another sheet but
> > unfortunately those sheets with graphs don't appear in link window box.
Is
> > it possible?
> > TIA Rasoul Khoshravan
> >
> >
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>

There are lots of things that can go wrong.

One of those things is that macros are disabled.

If you close and reopen this workbook, do you get prompted to allow macros to
run? If you did, did you say ok?

Did you get a message back when you selected I182?

Jon has a line in his code that gives you a warning.
"No such chart exists."

If this didn't help (and it'd be pretty strange if it did!), you should post
back with more details of what went wrong.

Rasoul Khoshravan Azar wrote:
>
> Dear Debra
> Thanks for your comments. Although I don't understamd VBA so much but I
> copied the entire code of Jon Peltier to the view code of the tab (by right
> clicking) and correct the sell reference from B2 to I182 of mine then I
> saved and exited ther VBA editor but it didnt work. I am wondering if I am
> missing a step or doing something wrong.
> Your comments will be hilghy appreciated. TIA Rasoul Khoshravan
>
> "Debra Dalgleish" <dsd@contexturesXSPAM.com> wrote in message
> news:41E44E07.40708@contexturesXSPAM.com...
> > You can't hyperlink to the chart sheet, but Jon Peltier has a macro
> > workaround in his Charting FAQ article:
> >
> > http://pubs.logicalexpressions.com/P...?ID=209#jon016
> >
> > that you may be able to use.
> >
> >
> > Rasoul Khoshravan Azar wrote:
> > > I have a list of 100 company names in a sheet called: Names
> > > In other sheets (not 100 sheets but about 30 sheets) I draw a graph of
> daily
> > > price for those companies. Graphes are stored as sheet not as object and
> > > there is only graph with no data cells
> > > I want to create a link in my main sheet (Names) so if I click it, Excel
> > > goes to that companie's sheet.
> > > I know how to create a link between a cell and another sheet but
> > > unfortunately those sheets with graphs don't appear in link window box.
> Is
> > > it possible?
> > > TIA Rasoul Khoshravan
> > >
> > >
> >
> >
> > --
> > Debra Dalgleish
> > Excel FAQ, Tips & Book List
> > http://www.contextures.com/tiptech.html
> >

--

Dave Peterson