Question

Stated simply my question is as follows Is it possible for a button on a worksheet in a normal excel workbook (.xlsx not .xlsm) to trigger a macro in another file specifically an installed excel add in (.xlam).

在这方面,我为什么要做到这一点。我有一本工作手册,许多用户需要能够看到,但只有一些用户需要能够更新,填写在另一张表格上,并用一个宏观添加。工作单不应包含任何宏观措施,以避免正常用户开启的安全警告。我可以这样做,在添加一个rib子,即用户点击,然后检查正确的工作手册是开放的,表格是填充的。在实施更新守则之前。但是,如果 but子不出现在rib子上,而坐在工作桌上不低于表格,那么接口就会变得nic。因此,我的问题是,有可能从纽托尼点点击非宏观化工作手册引发外部宏观。

Answer 1

I don t see how you can execute a macro from a control in a non-macro-enabled workbook.

Answer 2

是的,你可以将外部宏观(应当xlsm file)转让给非macro-enabled workbook(.xlsx)纽顿。我的xsm 宏观与简化的xlsx工作书相同的目录。 (说明:我使用Excel 2010)

Firstly, you must open your xlsm macro in the same instance of Excel window (i.e. do not open a new instance of Excel) so that your xlsx workbook will be able to see/access it.
Right-click on your xlsx workbook button and select "Assign Macro..."
Make sure you select Macros in: All Open Workbooks
All macros in open workbooks will be shown (this is why it is important to do step 1).
Select the desired macro from the list then click OK.

友情链接