Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Running Excel 2000 VBA Application on Excel 2003 Excel Worksheet Functions 0 August 8th 06 06:04 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
Difference in number of Excel NewsGroups Hari Prasadh Excel Discussion (Misc queries) 1 January 25th 05 11:32 AM
Query a Access database that has a module from Excel Oggie Excel Discussion (Misc queries) 1 January 4th 05 08:43 AM


All times are GMT +1. The time now is 09:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"