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

Compile Error 2
visual basic code in 2003 vs 2007 1
Can't turn off visual basic debugger in Excel 2003 1
Compile Error: TPUtils 1
On opening program get MS Visual Basic error 1
Imported Visual Basic Module - Save Macros for use in Excel 1
Visual Basic Editor 3
Access 2003 and excel 0

Top