Link to Macro in word document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Carrie-Bo - 26 Oct 2005 14:37 GMT

Hi

I have recorded a simple macro in word to copy and paste an extra section of
a table if required. I would like to have a button or link in the actual
document that one could click on which would then simply paste the table.
This will be a shared document so would really need to be embedded.

Does anyone hav eany idea how I would do this, and if I have explained
properly?!

Many thanks

Reply to this Message

Greg - 26 Oct 2005 14:47 GMT

How about a macrobutton.

CTRL+F9. In the field delimiters that appear { }. Type; MacroButton
YourMacroName

Toggle the field display. Double click to fire the named macro.

Reply to this Message

Carrie-Bo - 26 Oct 2005 14:56 GMT

Thanks VERY much for this....but to make it more complicated, this will be in
a protected form - and doesn't seem to let me protect the form once I have
done this? Any ideas?

Yours gratefully

Reply to this Message

Greg - 26 Oct 2005 15:07 GMT

Adding a macrobutton shouldn't prevent you from protecting the
document. I did neglect to point out that you need to add a prompt to
the button.

{ Macrobutton YourNamedMacro "Double click to add to table"}

Are you pasting the table into an unprotected section of the document?
If not, your macro will also need code to unprotect and reprotect the
document.

Reply to this Message

Rate this thread: