VBA控制着色带？ [英] VBA control over the ribbon?

问题描述

我正在为Excel 2010创建一个VBA加载项，我使用了 Microsoft Office的自定义UI编辑器创建自己的功能区的工具。
但是，我想给用户选择加载我的加载项而不显示功能区，或者可以将功能区的不同部分看到。

I am in the process of creating a VBA add-in for Excel 2010, and I used the "Custom UI Editor for Microsoft Office" tool to create my own ribbon. However, I would like to give the user the option to load my add-in without displaying the ribbon, or with different parts of the ribbon visible.

使用菜单，我知道您可以以编程方式完全控制它们，但是色带似乎工作方式不同。

With menus, I know you can completely control them programmatically, but ribbons seem to work differently.

有没有办法在VBA中不加载我的 customUI.xml 功能区选项卡在启动时？

有没有办法从运行时删除（或添加项目）这些选项卡中的项目？

Is there a way in VBA to not load my customUI.xml ribbon tabs on startup?
Is there a way to remove items from (or add items to) these tabs at runtime?

推荐答案

这是关于这个主题的一大堆帮助真棒丝带帮助。我认为第2点和第3点对你特别感兴趣。

here is a whole slew of help on this subject Awesome Ribbon Help. I think points 2 and 3 are of particular interest to you.

这篇关于VBA控制着色带？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！