set app.vis=false then closed VBA! How to get wrkbk visible?

[joefrench]

I've just run some code that sets Application.visible=false and loads a userform. I then closed both the userform & vbeditor . I've actually done this before and was able to get the app back but do not remember how. Any ideas out there? The actual workbook is still in session. I have tried the following with no results:

For Each Workbook In Workbooks
If Workbooks.Application.Visible = False Then
Workbooks.Application.Visible = True
End If
Next

Any suggestions would be greatly appreciated!

 

[royUK]

Use the Query_Close event of the UserForm

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
Application.Visible = True
End Sub

 

[joefrench]

I can't access the UserForm (I don't think). I closed VBE so the entire application is hidden including any modules/forms.

 

[joefrench]

The following opened the file but was not the version in session:

Application.Workbooks.open ("Directory\Program.xls")

Maybe there is something similar which will set the filename visibility to True?

 

[joefrench]

In the task manager, I can see the UserForm. I can also see it through Alt+Tab. There's gotta be a way I can either make the UserForm visible or the Workbook visible.

 

[joefrench]

WOW do I feel like an idiot.........

If this happens to anyone else, try going to the directory in which your file is stored and double click (open) the file.

 

[royUK]

Sorry, I thought you wanted code to avooid this. You could actually place the code I posted in the UserForm_Click event whilst developing to avoid this.

 

[tusharm]

Even better...don't hide the application!

WOW do I feel like an idiot.........

If this happens to anyone else, try going to the directory in which your file is stored and double click (open) the file.

 

[VoG]

If you want to 'hide' the application behind the UserForm see http://www.mrexcel.com/board2/viewtopic.php?t=290564

 

[joefrench]

royUK - Thank you. That will be handy during development.

Tushar - Believe me, I'd rather not hide the app....unfortunately the person that I am developing this for is not too computer savvy and at the same time, extremely click happy. I'm planning on hiding the app and having her work through a userform to avoid confusion/problems.

VOG II - Thank you. I actually have some similar code to maximize the UserForm. I still think that I want to hide the app....I just need to be a bit more careful myself during development.

Thank you all.