Compile error on workbook open

[c.davidson]

I have been notified of an issue with a program on our network that I have been assigned to fix. I have opened the workbook and receive the error "Compile error in hidden module: ThisWorkbook." and from this no combox boxes are populated and the sheet doesn't work. When I open up the module ThisWorkbook and just run the macro from VBA, the workbook behaves and works as it should do. I have checked all the passwords for protected sheets and they all match up correctly. Why does the workbook do this on open but not when I run the macro from VBA?

[TMS]

Difficult to know without seeing the code and, ideally, a sample workbook with any sensitive information removed. It's a compile error, not a run time error, so passwords, etc., sholdn't matter..

Have you tried compiling the code/project to see if it complains?


Regards, TMS

[c.davidson]

From my knowledge the program was written in Office 2007, and since then we have updated to 2010. As the program interacts with some CAD software, I went into the References and unchecked the CAD software tools, then rechecked them, and this seems to have solved the issue. I'm not sure if this has something to do with updating to 2010 but it seems to be fixed now.

[TMS]

I'm not sure if this has something to do with updating to 2010 ...

Probably. Well done for cracking it


Regards, TMS






If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.