Visual Basic error in Excel2000

S

SJH

Recently I started getting the following visual basic error when I start up
Excel2000 "Compile error in hidden module:AutoExecNew". I get the following
error when I close Excel "Compile error in hidden module:DistMon". When I
click "OK" the program continues and other than the PIA factor, it does not
seem to impact the operations of the program.

I have tried to reinstall Excel2000, but it did not fix the problem.

Short of upgrading, any ideas on how to fix.
 
C

Chip Pearson

It is a fault of one your add-ins. Go to the Tools menu, choose
Add-Ins, and uncheck each add-in, restarting each time. When you
uncheck the offending add-in, you will no longer receive the
error messages. Then, add back the add-ins, except for the one
that causes the problem.
 
S

SJH

Chip, only had 2 Add Ins. Removed both and restarted. The error message
did not go away.
 
S

SJH

Dave,

Thanx for the help. The link you provided relates to an error related to
Adobe Acrobat 5.0. I have never had this version, but do use Acrobat 6.0.
No updates seem to be available for this version.
 
D

Dave Peterson

Do you have multiple versions of pdfmaker.xla in multiple XLStart folders?

And the error message was exactly the same?
I moved pdfmaker.xla as suggested by the your link. Error message still came
up.
 

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

Top