Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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,144
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 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
 

Tags
macro transfer



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 08:26 PM.


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