View Single Post
  #6   Report Post  
Posted to microsoft.public.word.docmanagement
WordWorker WordWorker is offline
external usenet poster
 
Posts: 16
Default Hyperlink to Run a Macro

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.

"Greg Maxey" wrote:

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 wrote:
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" wrote:

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 wrote:
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 - Word MVP

My web site http://gregmaxey.mvps.org
Word MVP web site http://word.mvps.org


--
Greg Maxey - Word MVP

My web site http://gregmaxey.mvps.org
Word MVP web site http://word.mvps.org