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?

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

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?

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?

All of this is an attempt to get you to say more
clearly what's going wrong. Spell it out, please.
Like this: "When I select A5 and hit <Ctl-K,
I get a window to change the URL, but when I
then click on..." And so on.

--- "Squeaky" wrote:
I can insert a command button to run a Macro if I need to.
I have other ways around that, thats not a problem. I can't
seem to get the VBA to recognize the name of the spreasheet
that is on the hyperlink. The cells that contain the hyperlinks
will not change location, but the name of the spreadsheet in
the hyperlink and the order might.