hyperlinks and command buttons

Tony, I could be wrong, but...
A command button runs some code. If you ALSO want it to hyperlink, then I
would think you should place some code at the end of your existing code that
performs the hyperlink task for you. I don't think command buttons are
intended to do both.
*******************
~Anne Troy

www.OfficeArticles.com


"Tony" <Tony@discussions.microsoft.com> wrote in message
news:85021629-16DF-4DEB-A0F6-4CE7BB06AA7D@microsoft.com...
> I have a main document, which contains command buttons. Each of these
command
> buttons, has a different associated hyperlink attached to it, to open a
> different worksheet. The problem, is that when i save the main document,
> close it, and re-open it, the hyperlinks, no longer work, unless the
document
> is in "design mode" .
>
> Is there a way, for me to keep the hyperlinks active? I have tried to use
an
> auto_open macro, with no success. Also, i am no good at Visual Basic.
>
> Alternatively, if there is a template, available, which i can modify, to
> achieve the desired outcome, the location of it would be appreciated.
Thank
> you.

I have a main document, which contains command buttons. Each of these command
buttons, has a different associated hyperlink attached to it, to open a
different worksheet. The problem, is that when i save the main document,
close it, and re-open it, the hyperlinks, no longer work, unless the document
is in "design mode" .

Is there a way, for me to keep the hyperlinks active? I have tried to use an
auto_open macro, with no success. Also, i am no good at Visual Basic.

Alternatively, if there is a template, available, which i can modify, to
achieve the desired outcome, the location of it would be appreciated. Thank
you.

Tony, I could be wrong, but...
A command button runs some code. If you ALSO want it to hyperlink, then I
would think you should place some code at the end of your existing code that
performs the hyperlink task for you. I don't think command buttons are
intended to do both.
*******************
~Anne Troy

www.OfficeArticles.com


"Tony" <Tony@discussions.microsoft.com> wrote in message
news:85021629-16DF-4DEB-A0F6-4CE7BB06AA7D@microsoft.com...
> I have a main document, which contains command buttons. Each of these
command
> buttons, has a different associated hyperlink attached to it, to open a
> different worksheet. The problem, is that when i save the main document,
> close it, and re-open it, the hyperlinks, no longer work, unless the
document
> is in "design mode" .
>
> Is there a way, for me to keep the hyperlinks active? I have tried to use
an
> auto_open macro, with no success. Also, i am no good at Visual Basic.
>
> Alternatively, if there is a template, available, which i can modify, to
> achieve the desired outcome, the location of it would be appreciated.
Thank
> you.