Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-25-2016, 11:16 AM
trillium trillium is offline Link macro to Quick Access Toolbar? Windows 7 32bit Link macro to Quick Access Toolbar? Office 2007
Novice
Link macro to Quick Access Toolbar?
 
Join Date: Oct 2015
Posts: 4
trillium is on a distinguished road
Default Link macro to Quick Access Toolbar?

Hi



I would like to attach a macro to the Quick Access Toolbar in Word so that users can run the macro anytime they need to do batch formatting. I have the macro, it runs fine, as long as it's in the file itself.

However, it will be our Admin assistants who will be opening the files (generated from a system), so I need an easy way for all of them to have access to the SAME macro. I was hoping I could save the macro on a shared LAN and have them create a link to it through the Quick Access Toolbar? But I can't seem to make it work.

The other idea is to help each of them to instead the macro MANUALLY into their Normal.docm files (not idea, very computer UNsavy).

Any help/suggestions would be greatly appreciated! :-)
Reply With Quote
  #2  
Old 01-26-2016, 05:28 AM
gmayor's Avatar
gmayor gmayor is offline Link macro to Quick Access Toolbar? Windows 10 Link macro to Quick Access Toolbar? 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

An easy method is to save your macro and its ribbon or QAT (Quick Access Toolbar) button in a template and distribute that template for use as an add-in.
__________________
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
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Link macro to Quick Access Toolbar? Quick Access Toolbar Word 13 namedujour Word 8 08-12-2015 10:37 AM
Quick Access Toolbar/Macros not running salbergotti Word VBA 1 07-06-2014 06:40 PM
Link macro to Quick Access Toolbar? Email button on quick access toolbar castman Word 3 01-17-2012 02:24 PM
add macro to quick access toolbar TessaLee Word VBA 2 03-16-2011 06:31 PM
Quick Access Toolbar pmokover Word 0 10-30-2009 07:25 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:01 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