Compile error message?

[Alan Burke]

Help, I am getting the following message when I launch Excel, and a further
message when I close it. Other than that it seems to work OK. But I am fed
up having to close the messages.

On Launch:
Compile error in hidden module: AutoExexNew

On Closing
Compile error in hidden module: DistMon

The help file mentions something about unprotecting modules?
I am not an expert in Excel, Home User.

 

[Nick Hodge]

Alan

Sound like a rouge add-in. Open Excel, go to Tools>Add-ins... and deselect
everything checked. Close Excel and if the error has gone, add them back
one at a time, closing and opening excel each time and when it comes
back...that's the one

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)

 

[Dave Peterson]

Just to add to Nick's response...

Take a look here:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q307410
OFF: "Compile Error in Hidden Module" Error Message When You Start
Word or Excel

It points at PDFMaker.xla as being the culprit.

 

[Gord Dibben]

Alan

Take a look here:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q307410
OFF: "Compile Error in Hidden Module" Error Message When You Start
Word or Excel

It points at PDFMaker.xla as being the culprit.


Gord Dibben Excel MVP

 

[Nick Hodge]

Hey, hold on...are you guys cutting and pasting? Your's and Gord's reply
are identical down to the colon!

If you've seen me type, my way is far more painful ;-)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)

 

[Dave Peterson]

I would never cut and paste.
I would never cut and paste.
I would never cut and paste.
I would never cut and paste.
I would never cut and paste.
I would never cut and paste.
I would never cut and paste.
I would never cut and paste.
I would never cut and paste.
I would never cut and paste.
I would never cut and paste.
I would never cut and paste.
I would never cut and paste.
I would never cut and paste.
I would never cut and paste.
I would never cut and paste.
I would never cut and paste.
I would never cut and paste.
I would never cut and paste.

In fact, I typed this all out <vbg>.

(If only Bart Simpson could do it this quickly!)

 

[Alan Burke]

Thank you for your help, I did what you said and removed the PDFmaker.xla
and that fixed it.
I was :-( now I am Cheers

Alan