Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-28-2020, 02:06 PM
DexterM DexterM is offline How do I pass a Word VBA macro to a colleague? Windows 10 How do I pass a Word VBA macro to a colleague? Office 2019
Novice
How do I pass a Word VBA macro to a colleague?
 
Join Date: Mar 2020
Posts: 1
DexterM is on a distinguished road
Arrow 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?
Reply With Quote
  #2  
Old 03-28-2020, 06:28 PM
macropod's Avatar
macropod macropod is offline How do I pass a Word VBA macro to a colleague? Windows 7 64bit How do I pass a Word VBA macro to a colleague? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #3  
Old 03-29-2020, 01:21 AM
gmayor's Avatar
gmayor gmayor is offline How do I pass a Word VBA macro to a colleague? Windows 10 How do I pass a Word VBA macro to a colleague? Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

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
Reply With Quote
  #4  
Old 03-30-2020, 05:56 AM
Charles Kenyon Charles Kenyon is offline How do I pass a Word VBA macro to a colleague? Windows 10 How do I pass a Word VBA macro to a colleague? Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,081
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

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.
Reply With Quote
Reply

Tags
macro transfer

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I pass a Word VBA macro to a colleague? Pass a range to another macro to bold before em dash jeffreybrown Word VBA 2 09-12-2018 04:14 PM
How do I pass a Word VBA macro to a colleague? How to Pass Arguments in a Formula? tinfanide Excel Programming 2 10-13-2014 06:10 AM
How do I pass a Word VBA macro to a colleague? How to Pass Document to this Sub ilcaa72 Word VBA 1 01-28-2014 03:04 PM
How do I pass a Word VBA macro to a colleague? 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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:06 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft