跨文件名和用户的Excel自定义工具栏按钮 [英] Excel custom toolbar buttons across file names and users

问题描述

好的，我想这是我在此处询问的一个较大问题的第3部分: ExcelVBA打开旧文件

OK I guess this is Part 3 of a larger issue that I was asking about here: Excel VBA opening old file

我正在构建一个模板，其中包含一堆vlookup和一些自动化功能，整个团队将使用数据集的记录问题.我在Access中花了10分钟，但在这种环境下无法工作，因此我的Excel模板一直在发展，并有许多解决方法-从其他几个Excel文件导入原始数据，并将用户重定向到一个清单页面，其中显示了以下信息一种更简单的方法.

I'm building a template with a bunch of vlookups and some automation that a whole team of people is going to use record problems with datasets. It would have taken me 10 minutes in Access but no can do in this environment so my Excel template has been evolving with a bunch of workarounds - importing raw data from several other Excel files and redirecting the user to a checklist page that shows the info in a simpler way.

过去几天我遇到的问题是Excel认为我正在寻找同一文件的早期版本中的过程和/或宏.我已经在这个模板上工作了几个月了，直到我在自定义工具栏上做了一些按钮之后，我才完全没有遇到这个问题，这样人们就可以通过单击按钮来运行宏和过程.

The issue I was having for the past couple days is Excel thinking I'm looking for procedures and/or macros in previous versions of the same file. I have been working on this template for months and I didn't encounter this problem at all until I made some buttons on a custom toolbar so people will be able to run macros and procedures just by clicking a button.

这似乎是Excel的一个奇怪属性，如果我更改文件名并重新保存它(同样，这是一个模板，该模板将分发给全世界的人们)，则我创建的工具栏按钮将与上一个文件中的宏和/或vb过程.我在此找到了一些文档，并找到了一种解决方法:

It seems like a strange property of Excel that if I change the name of the file and re-save it (again, it's a template that will be distributed to people all over), the toolbar buttons I created are associated with the macro and/or vb procedure in the previous file. I found some documentation about this, and a way to fix it here: Macro button under customized ribbon tab tries to open old Excel file

但这太疯狂了，不是吗?每当我重命名/移动/复制有问题的文件时，我都无法导出自定义功能区，删除对文件的引用并重新导入它.如何在工作簿中创建按钮，无论该按钮的名称或位置如何，该按钮都可以在该工作簿中使用?

but this is crazy, no? I can't be exporting the custom ribbon, removing references to files and reimporting it every time I rename/move/copy the file in question. How do I create buttons in a workbook that will work in that workbook no matter what it's called or where it is?

谢谢大家！

推荐答案

在Chris下保存的文件类型是什么?是否保存为"Excel工作簿"?如果是这样，也许可以将其另存为"Excel Binary Workbook"这只是一个假设，尽管我已经阅读了.

What type of file is this saved under Chris? Is it saved as an "Excel Workbook"? If so maybe saving it as an "Excel Binary Workbook" This is just an assumption give what I have read though.

这篇关于跨文件名和用户的Excel自定义工具栏按钮的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！