获取调用宏的按钮的工作表 [英] Get the worksheet of the button which called the macro

问题描述

在VBA宏中，如何获取工作表对象(调用该宏的按钮所在的位置)?

In a VBA macro, how do I get the worksheet object where the button which called the macro is located?

我尝试过

ActiveSheet.shapes(Application.Caller).TopLeftCell.Worksheet.Name

但是我显然不需要使用 ActiveSheet 来获取它.

but I obviously need to not use ActiveSheet for obtaining it.

推荐答案

对于AJD单词，现阶段ActiveSheet似乎是最好的方法"

As for AJD words, "at this stage ActiveSheet appears to be the best way"

这篇关于获取调用宏的按钮的工作表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！