使用宏和自定义功能区按钮分发Global.MPT [英] Distribute Global.MPT with both macros and custom ribbon buttons

问题描述

为什么每次我想为Microsoft Office创建自定义内容时，我会为每个程序遇到不同的问题？对于Word，Excel和PowerPoint，我可以轻松添加自定义功能区选项卡和按钮，并具有这些触发器宏。我可以使用
自定义UI编辑器来修改normal.dot，例如只将该文件分发给所有用户。

Why is it that every time I want to create something custom for Microsoft Office that I run into separate problems for each program? For Word, Excel and PowerPoint, I can easily add custom Ribbon tabs and buttons and have those trigger macros. I can use Custom UI Editor to alter the normal.dot for example and just distribute that file to all users.

但是我可以在这个编辑器中打开Global.MPT吗？不，完全没有..但是我可以复制文件本身并分发它，但只有宏存储在其中。不是实际的自定义功能区..

But can i open Global.MPT in this editor? No, not at all.. I can however copy the file itself and distribute that, but only macros are stored in it. Not the actual customized Ribbon..

推荐答案

Hello Kenny，

Hello Kenny,

我无法回答问题的原因，但有一些解决方法：

I can't answer the why question, but there are a couple of workarounds:

1. 在文件>项目选项>自定义功能区，
   导入/导出按钮允许导出功能区设置。这为您提供了一个XML文件。您可以使用描述如何使用相同按钮导入此内容的说明表将此内容分发给您的用户。这是我目前正在使用的方法，
   并且依赖于用户的指示，但这是我分发给30个用户的最简单方法。我发现虽然我必须定期更新全局文件，但功能区设置不会经常更改。
2. 有一个
   MSDN文章描述了如何使用VBA执行此操作，但我没有设法在合理的时间范围内使其工作，所以放弃了。
3. 还有一个
   论坛帖子固定在MSDN Project VBA论坛的顶部，描述了如何创建VSTO加载项以在MS Project中设置功能区。我没有视觉工作室，所以不是ab; e探索这个选项。

1. In File > Project Options > Customize the Ribbon, the Import/Export button allows export your Ribbon settings. This gives you an XML file. You can distribute this to your users with an instruction sheet describing how to then import this with the same button. This is the method I'm using at the moment, and is dependent on users following instructions, but it was the easiest way for me to distribute to my 30 users. I find that while I have to do regular updates to the global file, the Ribbon settings don't change as often.
2. There is an MSDN article describing how you can do this with VBA, but I didn't manage to get this working within a reasonable timeframe so gave up.
3. There's also a forum post pinned to the top of the MSDN Project VBA forum describing how to create a VSTO add-in to set up the Ribbon in MS Project. I don't have visual studio so wasn't ab;e to explore this option.

我感到很痛苦，并且希望通过这个功能分享我自己的经验很有用。

I feel your pain, and hope sharing my own experince with this functionality has been useful.

Andrew

这篇关于使用宏和自定义功能区按钮分发Global.MPT的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！