Forum Discussion
Compile error in hidden module: CodeModule.
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.
If the code is run by clicking buttons or selecting a macro to run, it is likely to be in an ordinary module as a subroutine or a function. If it runs whenever you open the workbook or make a change the event handlers will be in modules specific to the workbook or sheet. It is also possible to use Class modules but that is less likely.
Under Tools / References you should be able to see the versions of libraries available for use. Unfortunately, I have forgotten what shows if something you need is missing or is the wrong version. What is puzzling is that the other machines you mention are relatively new; incompatibilities are more likely when old code is ported to new computers.