Situation:
Excel does not longer recognize an imported type or method.
Reason
Through uninstalling and re-installing a Excel imported library this may affect the library registration so Excel may not longer be able to resolve some type and method information contained in the library.
Solution
Open the references dialog.
Lookup the imported library its type or method was highlighted by Excel.
Remove the reference to the library from your Excel workbook.
Commit the removement using OK.
Save the Excel workbook changes (this is important).
Then re-open the references dialog.
Select the previously removed library.
Commit this step using OK.
Save the Excel workbook changes.
Now everything should work again as expected.