在没有自定义UI编辑器的情况下创建Excel 2007功能区 [英] Create Excel 2007 Ribbon without Custom UI Editor

问题描述

任何人都可以告诉我，是否可以在不使用自定义UI编辑器"软件的情况下在Excel 2007中创建自定义功能区?

Can anyone tell me if it's possible to create a custom ribbon in Excel 2007, without using the 'Custom UI Editor' software?

使用编辑器确实很容易，但是在我工作的地方，我们无法下载外部软件.还有其他方法可以像记事本，单词吗?

With the Editor it's really easy but where I work we can't download external software. Is there any other way to do it like with notepad, word??

在此先感谢

推荐答案

我也没有安装可执行文件的能力.我可以推荐两个免费的Excel插件，它们可以为像我们这样的人解决此问题. (完全公开，我只是创建了第二个插件，因此我回答了一个已有4年历史的问题.)

I also don't have the ability to install executables. I can recommend two free Excel addins that may solve this problem for people like us. (Full disclosure, I just created the second addin, hence my answer to a 4-year old question).

第一个是Andy Pope的 RibbonX视觉设计器，它可以让您编辑功能区或构建它们从头开始，并具有许多功能，包括带有所有内置按钮图像的表单，VBA回调存根生成器等.我已经使用了多年，并在此过程中学到了很多有关Ribbon XML的知识:

The first is Andy Pope's RibbonX Visual Designer It lets you edit ribbons or build them from scratch, and has lots of features, including a form with all the built-in button images, a VBA callback stub generator, and others. I've used this for years, and have learned a lot about Ribbon XML while doing so:

第二个是我刚创建的用于直接修改文本的代码.随着对Ribbon自定义UI XML的更加熟悉，我想要一种可以让我快速创建或修改XML文本的东西，因此我创建了

The second is one I just created to modify the text directly. As I became more familiar with Ribbon customUI XML, I wanted something that would let me create or modify the XML text quickly, so I created the yoursumbuddy customUI Ribbon XML Editor. It's features include instant XML Validation, the ability to edit installed addins and the handling of customUI and customUI14 at the same time:

这篇关于在没有自定义UI编辑器的情况下创建Excel 2007功能区的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！