通过Sharepoint与其他人共享自定义宏和自定义Excel功能区 [英] Sharing custom macros and custom Excel Ribbon with others via Sharepoint

问题描述

我和我的同事使用Excel 2013和Sharepoint

My colleagues and I use Excel 2013 and Sharepoint

我写了一些自定义宏，这些宏已存储在Personal.xlsb中 我还自定义了功能区，以添加一个标签来访问这些宏.

I have written some custom macros which I have stored in Personal.xlsb I have also customized the ribbon to add a tab to access these macros.

与同事共享这些宏和功能区的最佳方法是什么? (并保持更新)

What is the best way of sharing these macros and the ribbon with my colleagues? (and keeping them updated)

一种方法如下(每次更改时都需要这样做)

One way is as follows (and this needs to be done each time there is a change)

1. 右键单击功能区|自定义功能区|导入/导出|导出所有自定义项并将此XML文件发送给我的同事，并要求他们导入它
2. 将我的Personal.xlsb发送给我的同事，并要求他们以此来覆盖自己的人.

但是，有更好的方法-尽量减少同事的手动工作.

However is there a better way - involving manual effort on the part of my colleagues as little as possible.

我可能想将宏另存为共享点文档，然后编辑XML文档以指向该共享点文档.

I thought perhaps of saving the macros as a sharepoint document, and then editing the XML document to point to this sharepoint document.

推荐答案

我想出的最佳答案如下:

The best answer that I have come up with is as follows:

1. 不是将文件保存在personal.xlb中，而是保存在 AddIn (.xlam文件)
中
2. 通过用于Microsoft Office的自定义UI编辑器将菜单添加到加载项中(可从
3. 要将文件的链接发送给我的同事

1. Not to save the files in personal.xlb but to save them in an AddIn (an .xlam file)
2. To add the menus to the Addin via Custom UI Editor For Microsoft Office (downloadable from http://openxmldeveloper.org/blog/b/openxmldeveloper/archive/2009/08/07/7293.aspx)
3. To save the file in the "Shared With Everyone" folder of "SkyDrive Pro"
4. To send a link to the file to my colleagues

这似乎解决了所有问题.如果我进行更新，则看来如果我的同事重新启动计算机，则该插件会自动更新.

This seems to solve all the issues. If I do an update then it seems that if my colleagues restart their computer then the addin is updated automatically.

这篇关于通过Sharepoint与其他人共享自定义宏和自定义Excel功能区的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！