Re: link to sheets tabs

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Rasoul Khoshravan Azar (rasoulazar_at_hotmail.com)
Date: 01/12/05 

Date: Wed, 12 Jan 2005 04:40:38 +0330

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 ***, but Jon Peltier has a macro
> workaround in his Charting FAQ article:
>
> http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=209#jon016
>
> that you may be able to use.
>
>
> Rasoul Khoshravan Azar wrote:
> > I have a list of 100 company names in a *** 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 *** not as object and
> > there is only graph with no data cells
> > I want to create a link in my main *** (Names) so if I click it, Excel
> > goes to that companie's ***.
> > I know how to create a link between a cell and another *** 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
>

Quantcast