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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.