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

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
Who is Participating?
jasondimaioConnect With a Mentor Author Commented:
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.
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.

Patrick MatthewsConnect With a Mentor Commented:
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.
jasondimaioAuthor Commented:
I selected my answer as the solution because I had try this before but this time I open Excel as the administrator.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.