hyperlinks and command buttons

[Guest]

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.

 

[Anne Troy]

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