打开文件时防止自动运行VBA代码
我遇到了一个问题,我写了一个用户表单,在工作簿程序表中的on_open
下提供了application.visible = false
,现在我可以运行该程序,但无法打开工作簿或VBA程序.
I'm facing a problem where I have written a User form where I have provided the application.visible = false
in the workbook program sheet under on_open
, now I'm able to run the program but I'm unable to open the workbook or the VBA program.
请帮助
谢谢! Nagarjun B
Thank you and Regards, Nagarjun B
要防止自动运行VBA代码(例如Workbook_Open
或Auto_Open
),请单击文件›从菜单/功能区中打开,选择文件并按住Shift键(当您单击打开"按钮时).
To prevent autorun VBA code like Workbook_Open
or Auto_Open
click File › Open from the menu/ribbon, select your file and hold down the shift key when you click the Open button.
有关详细操作方法的信息,请参见:防止auto_open和Workbook_Open事件运行.
For a detailed how-to also see here: Preventing auto_open and Workbook_Open events from running.