How do I unlock a module in Excel?

[frustrated nun]

When I enter Excel I get the following error message from Microsoft Visual
Basic: "Compile error in hidden module: AutoFixNew" and when I exit excel I
get the error "Compile error in hidden module: Distmon". When I check help it
saus there is a locked hidden module. I can't even find these modules. Any
help would be greatly appreciated.

 

[Dave Peterson]

You sure it isn't autoexecnew?

If it is...


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.

If you move/delete that addin, you should be ok.

 

[Gord Dibben]

Sounds like the PDFMaker problem.

See KB article http://support.microsoft.com/default.aspx?scid=kb;EN-US;q307410

The PDFMaker.xla and maybe PDFMaker.dot are stored in your Office\XLSTART folder
or in the Excel\XLSTART folder.

Any files in these folders will open with Excel.

You must remove them from the XLSTART folder.


Gord Dibben MS Excel MVP

When I enter Excel I get the following error message from Microsoft Visual
Basic: "Compile error in hidden module: AutoFixNew" and when I exit excel I
get the error "Compile error in hidden module: Distmon". When I check help it
saus there is a locked hidden module. I can't even find these modules. Any
help would be greatly appreciated.

Gord Dibben MS Excel MVP