Vba userform unhide excel application

Question

0.00/5 (No votes)

See more:

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

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!!

Posted 6-Apr-17 21:38pm

planetz

Updated 6-Apr-17 22:27pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CHill60 · Accepted Answer · 2017-04-06T22:27:00

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