#1
|
|||
|
|||
How do I pass a Word VBA macro to a colleague?
If I send a colleague a Word document as an email attachment, will all my VBA Word macros go along automatically?
If the macros do go along, does the recipient have to do anything to activate them (make them available)? If they don't go along automatically, how do I explicitly pass over one or more macros? |
#2
|
||||
|
||||
If the macros are in the document, rather than its template, yes, they'll travel with the document.
Whether the recipient has to activate them depends on how their system's security is configured.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
||||
|
||||
If you simply want to share macros with a colleague, copy them to a template, complete with the ribbon/QAT (Quick Access Toolbar) commands to make them work, and ask your colleague to save the template in his/her Word startup folder.
If you have not changed the preferred startup folder it can be located (in English language versions of Windows) by typing %appdata%\Microsoft\Word\Startup in the Windows File Explorer Address bar and pressing Enter. The template will then load when Word is started and the macros and command buttons it contains will be available to his/her documents.
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#4
|
|||
|
|||
I would add keyboard shortcuts to your macros (if applicable) as something to be saved in the template holding the macros.
Here is more about adding QAT icons to a template. Modifying the Quick Access Toolbar (QAT) in Microsoft Word The subject of distributing macros has long been of interest in the Word online community. Organizing your macros by Beth Melton, Word MVP Organizing your Add-Ins by Greg Maxey If your colleague has reasonable security on the Word installation, the macros will not run without some authorization. Placing them in the Word Startup Folder is generally such authorization. |
Tags |
macro transfer |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Pass a range to another macro to bold before em dash | jeffreybrown | Word VBA | 2 | 09-12-2018 04:14 PM |
How to Pass Arguments in a Formula? | tinfanide | Excel Programming | 2 | 10-13-2014 06:10 AM |
How to Pass Document to this Sub | ilcaa72 | Word VBA | 1 | 01-28-2014 03:04 PM |
Can pass .expression as a parameter? | tinfanide | PowerPoint | 4 | 12-28-2012 06:14 PM |
How to pass parameters to a .msg file? | HereNow | Outlook | 0 | 11-05-2012 10:38 AM |