Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to locate auto_open preventing search for lost file?
In Excel 2003 - how to locate auto_open in a workbook to prevent search for a
non excistiong lost file? Same problem when closing the workbook. //Pls HELP |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to locate auto_open preventing search for lost file?
Press ALT+F8 to bring up the Macro dialog box. In that listbox,
select Auto_Open and click the Edit button. That will take you to the code. Delete the code. Also, open the ThisWorkbook code module and see if there is a procedure called Workbook_Open. You'll probably want to delete that too. For the error upon closing the file, look for a macro called Auto_Close and look in ThisWorkbook for BeforeClose. Delete these. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Tommy" wrote in message ... In Excel 2003 - how to locate auto_open in a workbook to prevent search for a non excistiong lost file? Same problem when closing the workbook. //Pls HELP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locating a file in excel with a partial file name. | Excel Discussion (Misc queries) | |||
Locating a file in excel with a partial file name. | Excel Discussion (Misc queries) | |||
Locating a file in excel with a partial file name. | Excel Discussion (Misc queries) | |||
Locating a file in excel with a partial file name. | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |