How to locate auto_open preventing search for lost file?

T

Tommy

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
 
C

Chip Pearson

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
 
Top