如何列出excel 2003工作表中的引用宏。 [英] How do i list the macros being references in an excel 2003 sheet.

问题描述

我正在处理一个庞大的Excel工作簿。



问题是我必须添加一个新行，并且所有的宏都不符合正确的单元格。



我想知道一种方法来查看单张（非工作簿）正在调用的所有宏。



我尝试了什么：



我点击了开发人员 - >宏，但他们不告诉我哪个表格参考它。



我想要像visual studio这样的东西找到所有引用的东西。

I am working with a huge excel workbook.

The issue is that I had to add a new line and all the macros are not wiriting to the correct cell.

I want to know a way to see all the macros that a single sheet(not workbook) is calling.

What I have tried:

I have clicked on developer-> macros but they dont tell me which sheet reference it.

I want some thing like visual studio find all references thing.

推荐答案

您可以编写一些VBA来列出工作表中的所有宏 - 请参阅此链接生成宏列表（ Microsoft Excel） [ ^ ]。除了给出的参考，您还需要引用Microsoft Visual Basic For Applications Extensibility Library。



理论上你可以做类似的事情来获得已经使用过的控件并将它们与宏名称相匹配 - 我在几年前做了类似的事情，但它在VB6中，我再也无法访问它了。



github上的这些东西可能会有所帮助 - Excel宏将此项目中的所有VBA源代码导出到文本文件以进行适当的源代码控制版本控制· GitHub [ ^ ]

You can write some VBA to list all of the macros in your worksheet - see this link Generating a List of Macros (Microsoft Excel)[^]. As well as the reference given you will need to have a reference to "Microsoft Visual Basic For Applications Extensibility Library".

In theory you can do something similar to get the controls that have been used and match them up to the macro names - I did something similar years ago but it was in VB6 and I no longer have access to it.

This stuff on github might help though - Excel macro to export all VBA source code in this project to text files for proper source control versioning · GitHub[^]

这篇关于如何列出excel 2003工作表中的引用宏。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！