link to sheets tabs

  • Thread starter Thread starter Rasoul Khoshravan Azar
  • Start date Start date
R

Rasoul Khoshravan Azar

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
 
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
 
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.
 
Back
Top