Hyperlink to Run a Macro

[WordWorker]

Is it possible to have a hyperlink run a macro?

If yes, how?

If no, suggest this capability be added to the next version of Word (and
Access, Excel, PowerPoint, et al).

 

[Greg Maxey]

AFAIK, no.

Have you cosidered a macrobutton field?

{MarcoButton ThisMacro "Click to run this macro"}

The field braces are entered using CTL+F9

ThisMacro is the name of the macro in the current project that you want to
run.

Toggle the field code and double click to run.

 

[WordWorker]

Greg,

I don't quite understand. (I'm not a macro or VBA programmer; I just sort
of stumble around with mostly macros by example and some simple
manipulations.)

Without giving a whole macro course, can you expand a bit on how to do what
you are talking about and how it works? Will it work in Word 2007? Will it
work in a locked doc?

WordWorker

 

[Greg Maxey]

WordWorker,

I have had no formal training myself so my use of technical terms may be a
little offbase.

A macro is a procedure stored in document project (either the ThisDocument
object or separate module)

Open the document. Open the VB Editor (VBE) using Alt+F11. If not
displayed, display the Project Explorer pane (CTRL+R).

In the explore pane click to expand the project. Insert the following code
in the "ThisDocument" object:

Sub ExampleMacro()
MsgBox "The example macro just executed"
End Sub

Close the editor.

In the document place the cursor where the link should appear and press
CTRL+F9

In the field braces that appear { } type in MacroButton ExampleMacro "Dbl
click to run macro"

Right click the field and toggle field codes.

Yes it works in Word2007 and yes it works in protected forms.

 

[WordWorker]

It Works! You may have just solved a major problem I am having with a locked
document. It was the "toggle field" that threw the whole thing off for me
because I didn't know about it. I turned field codes off differently, but
your way is much handier. Thank you so very much, Greg.