我和我的同事使用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)
但是,有更好的方法-尽量减少同事的手动工作.
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:
这似乎解决了所有问题.如果我进行更新,则看来如果我的同事重新启动计算机,则该插件会自动更新.
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功能区
发布评论