Execute a macro from a hyperlink 2

[KenWK]

In Word I have a macro that generates a document containing information for the user. One of the functions the user will need to perform is to open one or more files or folders.

I know I can use hyperlinks to open one file or folder at a time but is there a way to have a single hyperlink open multiple items or, possibly even better, run a macro in the template that is attached to that document?

Many thanks,
Ken

 

[combo]

If you accept double-click to run macro, use MACROBUTTON field, it can display text or shape. Alternatively you could insert commandbutton, label or other activex control and add the 'Click' event procedure.

combo

 

[fumei]

A hyperlink does one thing. Jumps focus to the Address of the hyperlink. This can be a document (ONE), or a bookmark (either in the cuurent document or another document), or a web page. In any case, a hyperlink jumps to an Address. Why are you using a hyperlink, and what does it Address to?

combo is right. If you are executing instructions, use one of many ways to execute instructions. This could be:

a MACROBUTTON, as combo suggests (although I am not fond of them myself)

a keyboard shortcut

a menu item

an icon on a toolbar

a commandbutton (an ActiveX control)

Any of the above methods will execute a macro procedure. A hyperlink does not.

Gerry

 

[KenWK]

Thanks a bunch guys! I'd forgotten about being able to put controls in an actual document.

For anyone as semi-clueless as I this is a great link for how to do so.

http://support.microsoft.com/kb/246299

All the best,
Ken