Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-04-2021, 10:58 PM
Florian Florian is offline Button to activate macro distributed in the company Windows 10 Button to activate macro distributed in the company Office 2016
Novice
Button to activate macro distributed in the company
 
Join Date: Jul 2021
Posts: 1
Florian is on a distinguished road
Question Button to activate macro distributed in the company


I would like to distribute a macro in the company and a button in the menu bar for this purpose. I have read that this only makes sense via XML and should also be done via an add-in and not via normal.dotm. Everything I have found so far (Custom UI Editor) refers to Office 2010 or older. Are there already simpler solutions for Office 2016? What do software developers use who want to integrate functions of their software into Office and also need buttons for this? My wish would still be a solution that can also be realised via normal.dotm and for which I do not have to learn the XML language completely. Does anyone have any tips for me?
Reply With Quote
  #2  
Old 07-04-2021, 11:52 PM
Guessed's Avatar
Guessed Guessed is offline Button to activate macro distributed in the company Windows 10 Button to activate macro distributed in the company Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,969
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

My tips are:
1. Don't do this via Normal.dotm. That template might have been customised by the individual user and you would be over-writing their personal productivity tools. Instead, consider doing this via an addin (template loaded as addin) or as a template which can be attached to existing documents or used to create new documents.
2. Custom UI Editor is a free way to edit the xml but you need to learn the basics of the RibbonUI xml. Years ago I knew of a relatively cheap xml editor that puts a GUI in the way so you didn't need to learn the xml. I can't recall its name but your GoogleFu might reveal it.
3. Software developers might choose to use Microsoft's Visual Studio or VSTO to create Office solutions which include buttons on ribbons. If you are worried about learning xml then this is not a good option for you but you could hire a developer who knows their way around in the tools.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 07-05-2021, 07:54 AM
Charles Kenyon Charles Kenyon is offline Button to activate macro distributed in the company Windows 10 Button to activate macro distributed in the company Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,125
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

Normal.dotm is not the way to distribute customizations. It should not be shared.
Use a separate Global Template. Methods for sharing such a template are on the linked page.

What you are talking about, I hope, is a button on the QAT. This is not normally called a "macrobutton." That modification should be stored in the same template as your macro; no ribbon modification is needed to do this. This is easy to do and requires nothing outside the tools built into Word.
Modifying the Quick Access Toolbar (QAT) in Microsoft Word

Here is information about the different MacroButton Field.

Custom UI Editor works fine for all ribbon versions of Word. I currently use Office RibbonX Editor, which is also free.


General rule: Just about anything that works for Word 2007 works in all later versions of Word.
Reply With Quote
Reply

Tags
macro-button via vba, normal.dotm



Similar Threads
Thread Thread Starter Forum Replies Last Post
Button to activate macro distributed in the company Use macro on form activate attached to read only file smarti Word VBA 3 03-02-2017 09:06 AM
as to activate a macro without operator input ? gianca53 Excel Programming 0 02-02-2017 09:09 AM
macro used to activate shortcut keys hudsontucker13 PowerPoint 1 12-14-2013 09:47 AM
Activate Worksheet with button in Excel 2013 JTS Excel 1 08-25-2013 12:02 AM
Run Macro & Activate shape ibrahimaa Excel Programming 1 01-21-2012 02:14 AM

Other Forums: Access Forums

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