PDA

View Full Version : Solved: How to retrieve a closed application



Mark$1
03-05-2008, 10:34 AM
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
03-05-2008, 10:45 AM
Go into the VBIDE, Alt-F11

In the Immediate window (Ctrl-G), type

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

mdmackillop
03-05-2008, 10:49 AM
You can prevent startup macros from running by holding down the shift key when you open the file.

Zack Barresse
03-05-2008, 11:01 AM
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
03-05-2008, 11:14 AM
Thanks for the help. It is much appreciated. You cant imagine the panic I was in!

Bob Phillips
03-05-2008, 11:56 AM
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 .... :think:

Zack Barresse
03-05-2008, 11:59 AM
Wha.. who... where.. ?? Oh, ahem, hi, my name is Zack. And I'm an Excel addict. Very pleased to meet you. :D