Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening "locked" application
Well, I've really done it to myself! I have an app. that I coded so that it
looks for some basic information (information in a database table) in the workbook.open event. If you hit an error, it causes the program to application.quit. This was included to prevent a user from entering data if the database is corrupted, not available, etc. Problem: I now want to change tihe address in the code where the app. looks for the information. But I can't open the app. because the informationn has been moved. So the app. automatiically closes. I'm locked out! [My bad.] Anyway, is there a way to interrupt the application as it load by some sort of key stroke (or some such) so that I can break into the code and make the necessary changes? Thank you for any input. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening "locked" application
Open the VBA Editor, press CTRL+G to view the Immediate Window and enter the
following followed by the ENTER key: Application.EnableEvents = False Now open your workbook. Then go back to VBA and enter the same command in the Immediate, but change False to True. Or you can hold down the SHIFT key when opening the workbook. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "Bruce Maston" wrote in message ... Well, I've really done it to myself! I have an app. that I coded so that it looks for some basic information (information in a database table) in the workbook.open event. If you hit an error, it causes the program to application.quit. This was included to prevent a user from entering data if the database is corrupted, not available, etc. Problem: I now want to change tihe address in the code where the app. looks for the information. But I can't open the app. because the informationn has been moved. So the app. automatiically closes. I'm locked out! [My bad.] Anyway, is there a way to interrupt the application as it load by some sort of key stroke (or some such) so that I can break into the code and make the necessary changes? Thank you for any input. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening "locked" application
Go to Tools-Macro-Security and select Medium. Open your workbook and
select disable macros. You can then go to the VBA Editor and make necessary changes to your code. "Bruce Maston" wrote: Well, I've really done it to myself! I have an app. that I coded so that it looks for some basic information (information in a database table) in the workbook.open event. If you hit an error, it causes the program to application.quit. This was included to prevent a user from entering data if the database is corrupted, not available, etc. Problem: I now want to change tihe address in the code where the app. looks for the information. But I can't open the app. because the informationn has been moved. So the app. automatiically closes. I'm locked out! [My bad.] Anyway, is there a way to interrupt the application as it load by some sort of key stroke (or some such) so that I can break into the code and make the necessary changes? Thank you for any input. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening "locked" application
Thank you both for your response. Yes, this absolutely solves the problem.
"Bruce Maston" wrote: Well, I've really done it to myself! I have an app. that I coded so that it looks for some basic information (information in a database table) in the workbook.open event. If you hit an error, it causes the program to application.quit. This was included to prevent a user from entering data if the database is corrupted, not available, etc. Problem: I now want to change tihe address in the code where the app. looks for the information. But I can't open the app. because the informationn has been moved. So the app. automatiically closes. I'm locked out! [My bad.] Anyway, is there a way to interrupt the application as it load by some sort of key stroke (or some such) so that I can break into the code and make the necessary changes? Thank you for any input. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
"WinForm Application" to act as "RTD Server" using .Net | Excel Discussion (Misc queries) | |||
"WinForm Application" to act as "RTD Server" using .Net | Excel Programming | |||
Opening An Excel Application and "Analysis ToolPac" does not load | Excel Programming |