Forum Discussion
Compile error in hidden module: CodeModule.
When you say 'try to edit', is it the worksheet formulas that you are trying to edit or the VBA?
What you need is to have the code window open in order to see the module that is failing. This is a blind guess but it might be that your new machine is set up to run 64 bit Office but VBA code is trying to call 32 bit libraries.
I am working with a Macro-enabled Excel file, is the worksheet that I try to edit. When I open the file, I get the error window (attached), then click "OK". Then I click in my macros icons in my Excel file and the same error window pops-up.
In my old laptop, every time It opens normally. And its not so old, Corei7-6600U and Win 10 64bits. And this excel file runs perfectly in all my other work colleagues laptops.
I don't know how to enter into that code window you are talking about, but I will find out.Thanks for the reply!
I am not thinking of anything exotic. Just the developer tab and click Visual Basic or Alt+F11 to open the VBA code window. As long as the project is not password protected, you should be able to look through the code.
I managed to unlock the Excel file, now I have access to the code. I should be able to "run the code", but I am still trying to figure this out.
