Software

Ask something
Discussion Locked

Hyperlinking in a Form

0 helpful
5 replies

by m*lenium

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I'm developing a protected form at work. I'd like to create drop-down menus from which each drop-down menu would be "hyperlinked" to a different source file. I would then run a macro to copy over information from that source file to the protected form and then close the source file. I've successfully written a macro to do this.

The problem is that you can't hyperlink from a protected form, however I've found a way to emulate this with a macrobutton field.

I'd like to know what you recommend to:

1. emulate a hyperlink in drop-down menus and,
2. how do you insert this "hyperlink" in a drop-down menu?

5 replies

by kees.valkenswaard

I am not quite sure if I understand your question. However, problems I had with protected forms I resolved in a macro [VBA code] which unprotects the form and protects it directly again. Make sure that the pass word is included in both the unprotectand protect statement. As a consequence you will have to protect the VBA code itself as well in order to avoid that anybody can read your form pass word.
It is necessary to run this code before entering anything in the form as you may loose information by he unprotect ? protect sequence.
May be this is what you here looking for. Else clarify your actions.
Good luck.

This discussion is closed to new replies.