Link to Macro in word document

C

Carrie-Bo

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
 
G

Greg

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.
 
C

Carrie-Bo

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
 
G

Greg

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top