我可以在没有打开包含宏的工作表的情况下运行宏吗? [英] Can I run a macro without even opening the worksheet which contains macro?
问题描述
我是否可以在不打开包含宏的工作表的情况下运行宏?
Can I run a macro without even opening the worksheet which contains macro?
例如:我有我的SheetA.xlsm中的宏(后者又调用SheetB.xlsx)。目前我为此分配了一个捷径,其中一旦我打开"SheetA.xlsm",并按Ctrl + Shift + R它会自动运行宏。
For e.g.: I have my macro in SheetA.xlsm (which in turn calls a SheetB.xlsx). Currently I have assigned a short cut for this, wherein once i open the "SheetA.xlsm" and press Ctrl+Shift+R it automatically runs the macro.
我可以在加载项中进行一些设置,即使不打开"SheetA.xlsm",也可以按Crtl + Shift + R在包含 " SheetA.xlsm"的文件夹中。并且宏自动开始运行?
Can i do some settings in Add-ins wherein even without opening the "SheetA.xlsm", suppose i press Crtl+Shift+R in the folder which contains the "SheetA.xlsm" and the macro automatically starts running?
这个问题可能非常荒谬:)
The question may be very absurd :)
推荐答案
简答题是'不',但您可以将宏放入加载项模板中,它始终可用。
The short answer is 'no', but you could put the macro in an add-in template and it would always be available.
这篇关于我可以在没有打开包含宏的工作表的情况下运行宏吗?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!