Hyperlink to Run a Macro

  • Thread starter Thread starter WordWorker
  • Start date Start date
W

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).
 
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.
 
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
 
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.
 
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.
 
Back
Top