If you have installed Excel 2003/2007 and Adobe Professional 7, 8 or 9, you may get the following error when you start Excel 2003 or Excel 2007:
"Compile Error in Hidden Module: Distmon"
The cause of this error is PDFMaker.xla, which loads at startup.
The easiest solution is to delete PDFMaker.xla from your computer. Since Adobe Professional 8 uses DLL-addins to add the toolbar in Excel, you can safely delete the PDFMaker.xla file on your computer.
PDFMaker.xla may be at one or more locations on your computers.
Typically, PDFMaker.xla is stored in your profile directory:
C:\Documents and Settings\<user>\Application Data\Microsoft\Excel\XLSTART\PDFMaker.xla
In other scenarios, PDFMaker.xla is stored in your Program Files directory.
After you deleted the file PDFMaker.xla, the error "Compile Error in Hidden Module: Distmon" at startup of Excel shouldn’t appear. To be sure you delete all PDFMaker.xla files, you can search your C:\ drive for all PDFMaker.xla. Make sure you search in subfolders and hidden files and folders.
The error described above has been occured in combination with the following applications:
- Adobe Acrobat Professional 7
- Adobe Acrobat Professional 8
- Adobe Acrobat Professional 9
- Microsoft Office Excel 2003
- Microsoft Office Excel 2007