打开文件时防止自动运行VBA代码 [英] Prevent autorun VBA code when opening a file

问题描述

我遇到了一个问题，我写了一个用户表单，在工作簿程序表中的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.

这篇关于打开文件时防止自动运行VBA代码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！