visual basic compile error in excel 2003

P

poopscooper101

i recently had to reinstall excel and now when i open an existing spreadsheet
containing macros, excel takes me immediately into visual basic debugger.
my only escape from this is to end program from windows task manager. all
these spreadsheets worked fine until i had to reinstall excel. please help!
 
D

Dave O

Just a guess- here's something to try while waiting for a more
informed response. Open Excel and on the menu click >Tools >Add-Ins
and check anything with VBA in the title: analysis toolpak VBA, etc.

Dave O
Eschew obfuscation
 
J

Jim Rech

With any workbook that does this active, I'd go to the VBE and check Tools,
References for references marked "missing".
 
Top