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".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

visual basic code in 2003 vs 2007 1
Compile Error 2
Visual Basic Macros 3
Compile Error: TPUtils 1
Can't turn off visual basic debugger in Excel 2003 1
Imported Visual Basic Module - Save Macros for use in Excel 1
Visual Basic Function works fine in Excell 2003 but not in Excel 2 8
On opening program get MS Visual Basic error 1

Top