Thread: [Solved] How do I pass a Word VBA macro to a colleague?
View Single Post
 
Old 03-29-2020, 01:21 AM
gmayor's Avatar
gmayor gmayor is offline Windows 10 Office 2016
Expert
  
Join Date: Aug 2014
Posts: 4,106
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