Hyperlinks to sheets in a workbook

  • Thread starter Thread starter KLassman
  • Start date Start date
K

KLassman

I inherited a workbook with 20 tabs, that has hyperlinks on the firs
tab to most of the other tabs. I have added a new tab, and change
the name of one of the tabs. However, I cannot figure out how t
make the hyperlinks work for these two pages. When I do the "Edi
Hyperlinks" procedure I get a list of the tabs in the workbook --- bu
not all of them . . . so I need to know how to get my tab names to sho
on that list.

I've tried reading some of the other postings, but none of them dea
with my problem.

I am not familiar with VBE (?) programming . . . and wouldn't know i
the former user used that or not. If that is the only solution t
this dilemma, you'll also need to tell me how to find where th
programming is!!

Thanks in advance for any assistance. I have learned SO MUCH fro
reading these pages
 
I'm not sure why they're not showing up, but if you look at one of the working
hyperlinks, maybe you could just type in your new link using that format.

And I find the =hyperlink() formula sometimes easier to work with:

=HYPERLINK('my Sheet'!A1,"go to my sheet")
 
Back
Top