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?