Library Not Found
Solved
Thibodeau19
Posted messages
30
Status
Membre
-
Chelhydra -
Chelhydra -
Hello,
For a month, I worked with the trial version of Microsoft Excel 2013. During that time, I named some cells to simplify certain VBA functions. Now that my trial period is over, I'm back on Excel 2010, but my macros no longer work. I'm getting a message saying: "compilation error, library not found." The problem appears to stem from the cells I named.
How can I resolve this issue?
Thank you.
Configuration: Windows 7 / Chrome 25.0.1364.152
For a month, I worked with the trial version of Microsoft Excel 2013. During that time, I named some cells to simplify certain VBA functions. Now that my trial period is over, I'm back on Excel 2010, but my macros no longer work. I'm getting a message saying: "compilation error, library not found." The problem appears to stem from the cells I named.
How can I resolve this issue?
Thank you.
Configuration: Windows 7 / Chrome 25.0.1364.152
2 réponses
Hello,
Cala means that there are likely missing references.
To do this, you need to go to the VBA editor (Alt+F11)
Go to the "Tools" menu and then to the "References" submenu
In the table, check if there are any checked references that are marked as Missing.
In that case, uncheck them and test again.
EDIT: I’ll add that you need to save the workbook and open it again
See you later
Best regards,
Cala means that there are likely missing references.
To do this, you need to go to the VBA editor (Alt+F11)
Go to the "Tools" menu and then to the "References" submenu
In the table, check if there are any checked references that are marked as Missing.
In that case, uncheck them and test again.
EDIT: I’ll add that you need to save the workbook and open it again
See you later
Best regards,
Ticho
This solved my problem. Thank you.
Chelhydra
I'm struggling since this morning! Thank you very much for the solution.