Vba userform取消隐藏excel应用程序 [英] Vba userform unhide excel application

问题描述

大家好，



我已经在excel中为某些应用程序创建了一个userform。在这个过程中，我使用以下代码使excel隐藏只显示表单：

Hi All,

I have made an userform in excel for some application. In the process, I made the excel hide to show only the form using the following code:

Private Sub Workbook_Open()
Application.Visible = False
UserForm1.Show
End Sub

我的问题是它工作得很好，现在我无法看到自己的代码！我无法打开我的vba编辑器!!如何让应用程序再次可见？请帮助!!



我尝试过：



我有尝试反复打开和关闭应用程序，右键单击，按alt + f11。什么都行不过!!

My problem is that it worked so fine that now I am not able to see my own code!! I am not able to open my vba editor!! How can I make the application visible again?? Please help!!

What I have tried:

I have tried opening and closing the application again and again, right clicking, pressing alt+f11. Nothing works!!

推荐答案

对不起，我笑了一下。但只是因为它也发生在我身上:-D



你必须打开电子表格而不运行宏...



1.从开始菜单打开Excel（不要选择任何以前的工作簿）



2.使用文件，打开菜单，找到问题工作簿并突出显示它（不要双击它！



3.按住[SHIFT]键并单击打开按钮。在工作簿满载之前不要放开[SHIFT]键（我需要一段时间才能解决这个问题）



4你现在应该可以从Workbook_Open中删除代码了。



我想你已经意识到如果你使Excel应用程序不可见，你的表单也将是隐形的。 ..因为它是应用程序的一部分

Sorry, I did laugh a little bit. But only because it has happened to me too :-D

You have to open the spreadsheet without running macros...

1. Open Excel from the Start Menu (do not select any previous workbooks)

2. Using the File, Open menu, locate your problem workbook and highlight it (don't double click it!

3. Hold down the [SHIFT] key and click the 'Open' button. Don't let go of that [SHIFT] key until the workbook is fully loaded (it took me a while to get my head around that bit)

4. You should be ok now to remove the code from Workbook_Open.

I guess you have realised that if you make the Excel application invisible, your form will be invisible too ... as it's part of the application

这篇关于Vba userform取消隐藏excel应用程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！