Hi Bob,

Actually I worked it out. I realized I did not need the hidden binders to
have an actual hyperlink so I eliminated that. In case you are wondering, I
answered your questions in-between.

"Bob Bridges" wrote:

I can't tell exactly what you're saying. Let's spell it out:

1) Can you, without using VBA, create a hyperlink from a
cell in one worksheet that when clicked will switch over
to display another worksheet?

Yes. I use a VBA code to list all of the Tab names on a spreadsheet, then
use hyperlink code so when I select the spreadsheet name, that spreadsheet
becomes active. Works fine.

2) Can you write VBA code that, when executed, will
change the active sheet from one to another?

Sure.

3) You say you can't get VBA to recognize the
worksheet name that is in the hyperlink. I think
you mean you have a hyperlink set up, of the
type I mention in question 1, and you also have
some VBA code trying to read it. a) What
advantage do you get from combining both?
And b) I've never tried that, but from the
documentation I see how the various objects
should interact; what error are you getting?

Since the names of the spreadsheets can change names and locations, I was
using a hyperlink formula with an Indirect command. I think that was
confusing VBA.
Once I removed that from the hidden folders it started working.

4) You say "The cells that contain the hyperlinks
will not change location". a) By "location" you
mean the URL each link is pointing to, right? b)
Do you mean you try to change the destination
address of a link and cannot? Why not?

I meant that cell c3 will contain the name of the first hidden document,
cell c4 will contain the second, etc. The names of the links will change as
the spreadsheet names do, but c3 will always contain the name of the first
hidden document.
No to the last question.