How to embed hyperlink to another document into an ActiveX Control Text Box

[kenboy21]

Hello All -


Obviously I'm new here, so let's get to the point. I am looking for advise on how one would click an ActiveX Control Text Box and it would open another document through some type of embedded hyperlink.

P.S. I am very intermediate with VBA, so please be easy on me

Any suggestions would be greatly appreciated.

Kind Regards...

[gmayor]

Where is the other document stored and will users of the document have access to that location? It would help to know EXACTLY what it is that you are trying to achieve.

[kenboy21]

gmayor. I have .docx in a network folder that is currently hyperlinked to another .docx on a cover sheet in another folder and I would like to have the option for the user to click a button with a short acronym or title e.g. Scorecard versus seeing the long winded hyperlink address.

Thanks for the interest and let me know if my reply doesn't make sense.

[gmayor]

In that case simply use a shortened display text for your hyperlink e.g.
My Web Site