Go Premium for a chance to win a PS4. Enter to Win


Compile error in hidden module:module1 when opening or closing Excel 2010

Posted on 2012-05-29
Medium Priority
Last Modified: 2012-06-03
I get this error when I open or close Microsoft Excel 2010 on a Windows 7 machine. I have check all the add-ins and nothing is active. I have deleted the PDFMaker COM under add-ins, which was the only active COM and I still getting this error. I have also check to see is there is any "missing" references under the VB keys using ALT + F11. Any help is appreciated. Thanks
Question by:jasondimaio
  • 2
LVL 11

Expert Comment

ID: 38022772
Have you checked your personal workbook?

The easiest way to do this is to press alt-F11 and then look in all the modules.  I assume since it happens on everything you will find it in your always hidden personal workbook.  However once you open it there you should be able to quickly find the module on the upper left hand side of the VBA editor and look at the code.  

If you need any help just post what you find.

LVL 93

Assisted Solution

by:Patrick Matthews
Patrick Matthews earned 400 total points
ID: 38023165
It may also be an error in an add-in.

Remove all add-ins, then add them back one at a time to see which one is the culprit.

Accepted Solution

jasondimaio earned 0 total points
ID: 38024052
I rand Excel as the administrator and went to the add-ins under options and this time there was one Add-in that did not see before and this was checked, so I  unchecked it and  viola! Thank guys (@matthewspatrick and ScriptAddict) for your help in trying to get this resolved.

Author Closing Comment

ID: 38041374
I selected my answer as the solution because I had try this before but this time I open Excel as the administrator.

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

782 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question