How do I unlock a module in Excel?
 

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.

How do I unlock a module in Excel?
 

You sure it isn't autoexecnew?

If it is...


Take a look he

http://support.microsoft.com/default...;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.

frustrated nun wrote:

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

How do I unlock a module in Excel?
 

Sounds like the PDFMaker problem.

See KB article http://support.microsoft.com/default...;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


On Sat, 26 Aug 2006 08:37:01 -0700, frustrated nun
wrote:

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