Solved: How to retrieve a closed application

[Mark$1]

I have put this code in a workbook that as soon as it opens it is hidden. How do I reverse this or retrieve the workbook to fix the problem. Kinda new at VBA and realized I messed up.

Sub Open_Workbook()
Application.Visible = False
End Sub

Mark$1

[Bob Phillips]

Go into the VBIDE, Alt-F11

In the Immediate window (Ctrl-G), type

windows("the_workbook_name.xls").Visible=true

[mdmackillop]

You can prevent startup macros from running by holding down the shift key when you open the file.

[Zack Barresse]

You can still access the workbooks code modules even though it is hidden. So when you open the VBE, expand the workbook, double click the ThisWorkbook module and edit the necessary code.

HTH

[Mark$1]

Thanks for the help. It is much appreciated. You cant imagine the panic I was in!

[Bob Phillips]

You can still access the workbooks code modules even though it is hidden. So when you open the VBE, expand the workbook, double click the ThisWorkbook module and edit the necessary code.

HTH

That name seems familiar ....

[Zack Barresse]

Wha.. who... where.. ?? Oh, ahem, hi, my name is Zack. And I'm an Excel addict. Very pleased to meet you.